Interface WindowFunctionBuilder.IOrderByPart<TThenPart>

Namespace

LinqToDB

Assembly

linq2db.dll

Provides ORDER BY for the window function.

public interface WindowFunctionBuilder.IOrderByPart<out TThenPart> where TThenPart : class

Type Parameters

TThenPart

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>)

Remarks

A key that holds the same value for every row - a literal, or a captured local that reaches SQL as a parameter - orders nothing, so it is dropped. Where dropping would empty the clause and the provider requires an ordering inside OVER, the key comes back as a scalar subquery keeping its value, direction and NULLS position.

Methods

OrderBy(object?)

Adds an ORDER BY column ASC clause.

TThenPart OrderBy(object? orderBy)

Parameters

orderBy object

Returns

TThenPart

OrderBy(object?, NullsPosition)

Adds an ORDER BY column ASC [NULLS FIRST|LAST] clause. NULLS ordering is emulated on providers that don't support it natively.

TThenPart OrderBy(object? orderBy, Sql.NullsPosition nulls)

Parameters

orderBy object

nulls Sql.NullsPosition

Returns

TThenPart

OrderByDesc(object?)

Adds an ORDER BY column DESC clause.

TThenPart OrderByDesc(object? orderBy)

Parameters

orderBy object

Returns

TThenPart

OrderByDesc(object?, NullsPosition)

Adds an ORDER BY column DESC [NULLS FIRST|LAST] clause. NULLS ordering is emulated on providers that don't support it natively.

TThenPart OrderByDesc(object? orderBy, Sql.NullsPosition nulls)

Parameters

orderBy object

nulls Sql.NullsPosition

Returns

TThenPart