Interface WindowFunctionBuilder.ILeadLagFinal

Namespace

LinqToDB

Assembly

linq2db.dll

Builder for offset window functions: LEAD, LAG.

Chain: [.IgnoreNulls()|.RespectNulls()] [UseWindow(wnd)] | [PartitionBy(...)].OrderBy(...)[.ThenBy(...)]

Optional null treatment, then mandatory ORDER BY (via the inherited chain).

public interface WindowFunctionBuilder.ILeadLagFinal : WindowFunctionBuilder.INullTreatmentPart<WindowFunctionBuilder.IOPartitionROrderFinal>, WindowFunctionBuilder.IOPartitionROrderFinal, WindowFunctionBuilder.IUseWindow<WindowFunctionBuilder.IDefinedFunction>, WindowFunctionBuilder.IPartitionPart<WindowFunctionBuilder.IROrderByPartOThenByPartFinal>, WindowFunctionBuilder.IROrderByPartOThenByPartFinal, WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IThenByPartFinal>

Inherited Members

WindowFunctionBuilder.INullTreatmentPart<WindowFunctionBuilder.IOPartitionROrderFinal>.IgnoreNulls()

WindowFunctionBuilder.INullTreatmentPart<WindowFunctionBuilder.IOPartitionROrderFinal>.RespectNulls()

WindowFunctionBuilder.IUseWindow<WindowFunctionBuilder.IDefinedFunction>.UseWindow(WindowFunctionBuilder.IDefinedWindow)

WindowFunctionBuilder.IPartitionPart<WindowFunctionBuilder.IROrderByPartOThenByPartFinal>.PartitionBy(params object[])

WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IThenByPartFinal>.OrderBy(object)

WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IThenByPartFinal>.OrderBy(object, Sql.NullsPosition)

WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IThenByPartFinal>.OrderByDesc(object)

WindowFunctionBuilder.IOrderByPart<WindowFunctionBuilder.IThenByPartFinal>.OrderByDesc(object, Sql.NullsPosition)

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)