Table of Contents

Class WindowFunctionHelpers

Namespace
LinqToDB.Internal.Expressions
Assembly
linq2db.dll
public static class WindowFunctionHelpers
Inheritance
object
WindowFunctionHelpers

Methods

ApplyOrderBy(Expression, IEnumerable<(LambdaExpression lambda, bool isDescending, NullsPosition nulls)>) 

public static Expression ApplyOrderBy(Expression queryExpr, IEnumerable<(LambdaExpression lambda, bool isDescending, Sql.NullsPosition nulls)> order)

Parameters

queryExpr Expression
order IEnumerable<(LambdaExpression lambda, bool isDescending, Sql.NullsPosition nulls)>

Returns

Expression

BuildAggregateExecuteExpression(MethodCallExpression, int) 

public static Expression BuildAggregateExecuteExpression(MethodCallExpression methodCall, int sequenceIndex = 0)

Parameters

methodCall MethodCallExpression
sequenceIndex int

Returns

Expression

BuildAggregateExecuteExpression<TSource, TResult>(IQueryable<TSource>, Expression<Func<IEnumerable<TSource>, TResult>>) 

public static Expression BuildAggregateExecuteExpression<TSource, TResult>(IQueryable<TSource> source, Expression<Func<IEnumerable<TSource>, TResult>> aggregate)

Parameters

source IQueryable<TSource>
aggregate Expression<Func<IEnumerable<TSource>, TResult>>

Returns

Expression

Type Parameters

TSource
TResult

BuildAggregateWithKeep(MethodInfo, Expression, bool, Expression[], (Expression expr, bool descending, NullsPosition nulls)[])

Builds an aggregate window function with KEEP (DENSE_RANK FIRST/LAST) clause.

public static Expression? BuildAggregateWithKeep(MethodInfo sampleMethod, Expression argument, bool isKeepFirst, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] keepOrderBy)

Parameters

sampleMethod MethodInfo
argument Expression
isKeepFirst bool
partitionBy Expression[]
keepOrderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

BuildAverage(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression? BuildAverage(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildCorr(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildCorr(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildCount(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression BuildCount(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildCount(Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildCount(Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildCovarPop(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildCovarPop(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildCovarSamp(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildCovarSamp(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildCumeDist(Expression[], (Expression expr, bool descending, NullsPosition nulls)[]) 

public static Expression BuildCumeDist(Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy)

Parameters

partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

BuildDenseRank(Expression[], (Expression expr, bool descending, NullsPosition nulls)[]) 

public static Expression BuildDenseRank(Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy)

Parameters

partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

BuildFirstValue(Expression, Nulls, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildFirstValue(Expression argument, Sql.Nulls nullTreatment, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
nullTreatment Sql.Nulls
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildLag(Expression, Expression?, Expression?, Nulls, Expression[], (Expression expr, bool descending, NullsPosition nulls)[]) 

public static Expression BuildLag(Expression argument, Expression? offset, Expression? defaultValue, Sql.Nulls nullTreatment, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy)

Parameters

argument Expression
offset Expression
defaultValue Expression
nullTreatment Sql.Nulls
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

BuildLastValue(Expression, Nulls, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildLastValue(Expression argument, Sql.Nulls nullTreatment, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
nullTreatment Sql.Nulls
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildLead(Expression, Expression?, Expression?, Nulls, Expression[], (Expression expr, bool descending, NullsPosition nulls)[]) 

public static Expression BuildLead(Expression argument, Expression? offset, Expression? defaultValue, Sql.Nulls nullTreatment, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy)

Parameters

argument Expression
offset Expression
defaultValue Expression
nullTreatment Sql.Nulls
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

BuildLongCount(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression BuildLongCount(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildLongCount(Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildLongCount(Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildMax(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression? BuildMax(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildMedian(Expression, Expression[]) 

public static Expression BuildMedian(Expression argument, Expression[] partitionBy)

Parameters

argument Expression
partitionBy Expression[]

Returns

Expression

BuildMin(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression? BuildMin(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildNTile(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[]) 

public static Expression BuildNTile(Expression nTileArg, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy)

Parameters

nTileArg Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

BuildNthValue(Expression, Expression, Nulls, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?, From) 

public static Expression BuildNthValue(Expression argument, Expression nArg, Sql.Nulls nullTreatment, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null, Sql.From fromPosition = From.None)

Parameters

argument Expression
nArg Expression
nullTreatment Sql.Nulls
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?
fromPosition Sql.From

Returns

Expression

BuildPercentRank(Expression[], (Expression expr, bool descending, NullsPosition nulls)[]) 

public static Expression BuildPercentRank(Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy)

Parameters

partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

BuildPercentileContWindowed(Expression, (Expression expr, bool descending, NullsPosition nulls)[], Expression[]) 

public static Expression BuildPercentileContWindowed(Expression fraction, (Expression expr, bool descending, Sql.NullsPosition nulls)[] withinGroupOrderBy, Expression[] partitionBy)

Parameters

fraction Expression
withinGroupOrderBy (Expression expr, bool descending, NullsPosition nulls)[]
partitionBy Expression[]

Returns

Expression

BuildPercentileDiscWindowed(Expression, (Expression expr, bool descending, NullsPosition nulls)[], Expression[]) 

public static Expression BuildPercentileDiscWindowed(Expression fraction, (Expression expr, bool descending, Sql.NullsPosition nulls)[] withinGroupOrderBy, Expression[] partitionBy)

Parameters

fraction Expression
withinGroupOrderBy (Expression expr, bool descending, NullsPosition nulls)[]
partitionBy Expression[]

Returns

Expression

BuildRank(Expression[], (Expression expr, bool descending, NullsPosition nulls)[]) 

public static Expression BuildRank(Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy)

Parameters

partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

BuildRatioToReport(Expression, Expression[]) 

public static Expression BuildRatioToReport(Expression argument, Expression[] partitionBy)

Parameters

argument Expression
partitionBy Expression[]

Returns

Expression

BuildRegrAvgX(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildRegrAvgX(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildRegrAvgY(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildRegrAvgY(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildRegrCount(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildRegrCount(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildRegrIntercept(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildRegrIntercept(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildRegrR2(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildRegrR2(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildRegrSXX(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildRegrSXX(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildRegrSXY(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildRegrSXY(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildRegrSYY(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildRegrSYY(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildRegrSlope(Expression, Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], WindowFrameSpec?) 

public static Expression BuildRegrSlope(Expression argument1, Expression argument2, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument1 Expression
argument2 Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildRowNumber(Expression[], (Expression expr, bool descending, NullsPosition nulls)[]) 

public static Expression BuildRowNumber(Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy)

Parameters

partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

BuildStdDev(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression BuildStdDev(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildStdDevPop(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression BuildStdDevPop(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildStdDevSamp(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression BuildStdDevSamp(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildSum(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression? BuildSum(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildVarPop(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression BuildVarPop(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildVarSamp(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression BuildVarSamp(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildVariance(Expression, Expression[], (Expression expr, bool descending, NullsPosition nulls)[], AggregateModifier, WindowFrameSpec?) 

public static Expression BuildVariance(Expression argument, Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy, Sql.AggregateModifier modifier = AggregateModifier.None, WindowFunctionHelpers.WindowFrameSpec? frame = null)

Parameters

argument Expression
partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]
modifier Sql.AggregateModifier
frame WindowFunctionHelpers.WindowFrameSpec?

Returns

Expression

BuildWindowDefinition(Expression[], (Expression expr, bool descending, NullsPosition nulls)[]) 

public static Expression BuildWindowDefinition(Expression[] partitionBy, (Expression expr, bool descending, Sql.NullsPosition nulls)[] orderBy)

Parameters

partitionBy Expression[]
orderBy (Expression expr, bool descending, NullsPosition nulls)[]

Returns

Expression

ExtractOrderByPart(Expression, out Expression) 

public static (LambdaExpression lambda, bool isDescending, Sql.NullsPosition? nulls)[] ExtractOrderByPart(Expression query, out Expression nonOrderedPart)

Parameters

query Expression
nonOrderedPart Expression

Returns

(LambdaExpression lambda, bool isDescending, NullsPosition? nulls)[]