Interface WindowFunctionBuilder.IMultipleThenByPart<TValue>

Namespace

LinqToDB

Assembly

linq2db.dll

Provides additional ORDER BY columns after the first one in ordered-set aggregates, plus an optional FILTER (WHERE ...).

public interface WindowFunctionBuilder.IMultipleThenByPart<out TValue> : WindowFunctionBuilder.IDefinedFunction<TValue>, WindowFunctionBuilder.IFilterPart<WindowFunctionBuilder.IDefinedFunction<TValue>>

Type Parameters

TValue

Inherited Members

WindowFunctionBuilder.IFilterPart<WindowFunctionBuilder.IDefinedFunction<TValue>>.Filter(bool)

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

Methods

ThenBy(object?)

Adds an additional ORDER BY column.

WindowFunctionBuilder.IMultipleThenByPart<out TValue> ThenBy(object? orderBy)

Parameters

orderBy object

Returns

WindowFunctionBuilder.IMultipleThenByPart<TValue>

ThenBy(object?, NullsPosition)

Adds an additional ORDER BY column with NULLS position.

WindowFunctionBuilder.IMultipleThenByPart<out TValue> ThenBy(object? orderBy, Sql.NullsPosition nulls)

Parameters

orderBy object

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IMultipleThenByPart<TValue>

ThenByDesc(object?)

Adds an additional ORDER BY column (descending).

WindowFunctionBuilder.IMultipleThenByPart<out TValue> ThenByDesc(object? orderBy)

Parameters

orderBy object

Returns

WindowFunctionBuilder.IMultipleThenByPart<TValue>

ThenByDesc(object?, NullsPosition)

Adds an additional ORDER BY column (descending) with NULLS position.

WindowFunctionBuilder.IMultipleThenByPart<out TValue> ThenByDesc(object? orderBy, Sql.NullsPosition nulls)

Parameters

orderBy object

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IMultipleThenByPart<TValue>