Class AnalyticFunctions

Inheritance
System.Object
AnalyticFunctions
Namespace: LinqToDB
Assembly: linq2db.dll
Syntax
public static class AnalyticFunctions : object

Fields

| Improve this Doc View Source

FunctionToken

Token name for analytic function. Used for resolving method chain.

Declaration
public const string FunctionToken = null
Field Value
Type Description
System.String

Methods

| Improve this Doc View Source

Average<T>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Average<T>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Average<T>(Sql.ISqlExtension, Nullable<Object>, Sql.AggregateModifier)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Average<T>(this Sql.ISqlExtension ext, object? expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Sql.AggregateModifier modifier
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Average<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

Declaration
public static double Average<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Sql.AggregateModifier modifier
Returns
Type Description
System.Double
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Average<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

Declaration
public static double Average<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Sql.AggregateModifier modifier
Returns
Type Description
System.Double
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Corr<T>(IEnumerable<T>, Expression<Func<T, Nullable<Object>>>, Expression<Func<T, Nullable<Object>>>)

Declaration
public static decimal Corr<T>(this IEnumerable<T> source, Expression<Func<T, object?>> expr1, Expression<Func<T, object?>> expr2)
Parameters
Type Name Description
IEnumerable<T> source
Expression<Func<T, System.Nullable<System.Object>>> expr1
Expression<Func<T, System.Nullable<System.Object>>> expr2
Returns
Type Description
System.Decimal
Type Parameters
Name Description
T
| Improve this Doc View Source

Corr<TEntity>(IQueryable<TEntity>, Expression<Func<TEntity, Nullable<Object>>>, Expression<Func<TEntity, Nullable<Object>>>)

Declaration
public static decimal Corr<TEntity>(this IQueryable<TEntity> source, Expression<Func<TEntity, object?>> expr1, Expression<Func<TEntity, object?>> expr2)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, System.Nullable<System.Object>>> expr1
Expression<Func<TEntity, System.Nullable<System.Object>>> expr2
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
| Improve this Doc View Source

Corr<T>(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Corr<T>(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Count(Sql.ISqlExtension)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<int> Count(this Sql.ISqlExtension ext)
Parameters
Type Name Description
Sql.ISqlExtension ext
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<System.Int32>
| Improve this Doc View Source

Count(Sql.ISqlExtension, Nullable<Object>, Sql.AggregateModifier)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<int> Count(this Sql.ISqlExtension ext, object? expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Sql.AggregateModifier modifier
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<System.Int32>
| Improve this Doc View Source

Count<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<int> Count<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<System.Int32>
Type Parameters
Name Description
T
| Improve this Doc View Source

CountExt<TEntity>(IEnumerable<TEntity>, Func<TEntity, Nullable<Object>>)

Declaration
public static int CountExt<TEntity>(this IEnumerable<TEntity> source, Func<TEntity, object?> expr)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, System.Nullable<System.Object>> expr
Returns
Type Description
System.Int32
Type Parameters
Name Description
TEntity
| Improve this Doc View Source

CountExt<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

Declaration
public static int CountExt<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Sql.AggregateModifier modifier
Returns
Type Description
System.Int32
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

CountExt<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

Declaration
public static int CountExt<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Returns
Type Description
System.Int32
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

CountExt<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

Declaration
public static int CountExt<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier = Sql.AggregateModifier.None)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Sql.AggregateModifier modifier
Returns
Type Description
System.Int32
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

CovarPop<T>(IEnumerable<T>, Expression<Func<T, Nullable<Object>>>, Expression<Func<T, Nullable<Object>>>)

Declaration
public static decimal CovarPop<T>(this IEnumerable<T> source, Expression<Func<T, object?>> expr1, Expression<Func<T, object?>> expr2)
Parameters
Type Name Description
IEnumerable<T> source
Expression<Func<T, System.Nullable<System.Object>>> expr1
Expression<Func<T, System.Nullable<System.Object>>> expr2
Returns
Type Description
System.Decimal
Type Parameters
Name Description
T
| Improve this Doc View Source

CovarPop<TEntity>(IQueryable<TEntity>, Expression<Func<TEntity, Nullable<Object>>>, Expression<Func<TEntity, Nullable<Object>>>)

Declaration
public static decimal CovarPop<TEntity>(this IQueryable<TEntity> source, Expression<Func<TEntity, object?>> expr1, Expression<Func<TEntity, object?>> expr2)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, System.Nullable<System.Object>>> expr1
Expression<Func<TEntity, System.Nullable<System.Object>>> expr2
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
| Improve this Doc View Source

CovarPop<T>(Sql.ISqlExtension, T, T)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> CovarPop<T>(this Sql.ISqlExtension ext, T expr1, T expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr1
T expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

CovarSamp<T>(IEnumerable<T>, Expression<Func<T, Nullable<Object>>>, Expression<Func<T, Nullable<Object>>>)

Declaration
public static decimal CovarSamp<T>(this IEnumerable<T> source, Expression<Func<T, object?>> expr1, Expression<Func<T, object?>> expr2)
Parameters
Type Name Description
IEnumerable<T> source
Expression<Func<T, System.Nullable<System.Object>>> expr1
Expression<Func<T, System.Nullable<System.Object>>> expr2
Returns
Type Description
System.Decimal
Type Parameters
Name Description
T
| Improve this Doc View Source

CovarSamp<TEntity>(IQueryable<TEntity>, Expression<Func<TEntity, Nullable<Object>>>, Expression<Func<TEntity, Nullable<Object>>>)

Declaration
public static decimal CovarSamp<TEntity>(this IQueryable<TEntity> source, Expression<Func<TEntity, object?>> expr1, Expression<Func<TEntity, object?>> expr2)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, System.Nullable<System.Object>>> expr1
Expression<Func<TEntity, System.Nullable<System.Object>>> expr2
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
| Improve this Doc View Source

CovarSamp<T>(Sql.ISqlExtension, T, T)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> CovarSamp<T>(this Sql.ISqlExtension ext, T expr1, T expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr1
T expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

CumeDist<TR>(Sql.ISqlExtension)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<TR> CumeDist<TR>(this Sql.ISqlExtension ext)
Parameters
Type Name Description
Sql.ISqlExtension ext
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<TR>
Type Parameters
Name Description
TR
| Improve this Doc View Source

CumeDist<TR>(Sql.ISqlExtension, Nullable<Object>[])

Declaration
public static AnalyticFunctions.INeedsWithinGroupWithOrderOnly<TR> CumeDist<TR>(this Sql.ISqlExtension ext, params object? [] expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object>[] expr
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedsWithinGroupWithOrderOnly<TR>
Type Parameters
Name Description
TR
| Improve this Doc View Source

DenseRank(Sql.ISqlExtension)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<long> DenseRank(this Sql.ISqlExtension ext)
Parameters
Type Name Description
Sql.ISqlExtension ext
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<System.Int64>
| Improve this Doc View Source

DenseRank(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.INeedsWithinGroupWithOrderOnly<long> DenseRank(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedsWithinGroupWithOrderOnly<System.Int64>
| Improve this Doc View Source

Filter<T>(AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>, Boolean)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Filter<T>(this AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> func, bool filter)
Parameters
Type Name Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> func
System.Boolean filter
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

FirstValue<T>(Sql.ISqlExtension, T, Sql.Nulls)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> FirstValue<T>(this Sql.ISqlExtension ext, T expr, Sql.Nulls nulls)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Sql.Nulls nulls
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

KeepFirst<TR>(AnalyticFunctions.IAggregateFunction<TR>)

Declaration
public static AnalyticFunctions.INeedOrderByAndMaybeOverWithPartition<TR> KeepFirst<TR>(this AnalyticFunctions.IAggregateFunction<TR> ext)
Parameters
Type Name Description
LinqToDB.AnalyticFunctions.IAggregateFunction<TR> ext
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedOrderByAndMaybeOverWithPartition<TR>
Type Parameters
Name Description
TR
| Improve this Doc View Source

KeepLast<TR>(AnalyticFunctions.IAggregateFunction<TR>)

Declaration
public static AnalyticFunctions.INeedOrderByAndMaybeOverWithPartition<TR> KeepLast<TR>(this AnalyticFunctions.IAggregateFunction<TR> ext)
Parameters
Type Name Description
LinqToDB.AnalyticFunctions.IAggregateFunction<TR> ext
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedOrderByAndMaybeOverWithPartition<TR>
Type Parameters
Name Description
TR
| Improve this Doc View Source

Lag<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Lag<T>(Sql.ISqlExtension, T, Sql.Nulls)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension ext, T expr, Sql.Nulls nulls)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Sql.Nulls nulls
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Lag<T>(Sql.ISqlExtension, T, Sql.Nulls, Int32, T)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension ext, T expr, Sql.Nulls nulls, int offset, T default)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Sql.Nulls nulls
System.Int32 offset
T default
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Lag<T>(Sql.ISqlExtension, T, Int32)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension ext, T expr, int offset)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
System.Int32 offset
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Lag<T>(Sql.ISqlExtension, T, Int32, T)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension ext, T expr, int offset, T default)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
System.Int32 offset
T default
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

LastValue<T>(Sql.ISqlExtension, T, Sql.Nulls)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> LastValue<T>(this Sql.ISqlExtension ext, T expr, Sql.Nulls nulls)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Sql.Nulls nulls
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Lead<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Lead<T>(Sql.ISqlExtension, T, Sql.Nulls)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension ext, T expr, Sql.Nulls nulls)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Sql.Nulls nulls
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Lead<T>(Sql.ISqlExtension, T, Sql.Nulls, Int32, T)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension ext, T expr, Sql.Nulls nulls, int offset, T default)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Sql.Nulls nulls
System.Int32 offset
T default
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Lead<T>(Sql.ISqlExtension, T, Int32)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension ext, T expr, int offset)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
System.Int32 offset
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Lead<T>(Sql.ISqlExtension, T, Int32, T)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension ext, T expr, int offset, T default)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
System.Int32 offset
T default
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

ListAgg<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.INeedsWithinGroupWithOrderAndMaybePartition<string> ListAgg<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedsWithinGroupWithOrderAndMaybePartition<System.String>
Type Parameters
Name Description
T
| Improve this Doc View Source

ListAgg<T>(Sql.ISqlExtension, T, String)

Declaration
public static AnalyticFunctions.INeedsWithinGroupWithOrderAndMaybePartition<string> ListAgg<T>(this Sql.ISqlExtension ext, T expr, string delimiter)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
System.String delimiter
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedsWithinGroupWithOrderAndMaybePartition<System.String>
Type Parameters
Name Description
T
| Improve this Doc View Source

LongCount(Sql.ISqlExtension)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<long> LongCount(this Sql.ISqlExtension ext)
Parameters
Type Name Description
Sql.ISqlExtension ext
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<System.Int64>
| Improve this Doc View Source

LongCount(Sql.ISqlExtension, Nullable<Object>, Sql.AggregateModifier)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<long> LongCount(this Sql.ISqlExtension ext, object? expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Sql.AggregateModifier modifier
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<System.Int64>
| Improve this Doc View Source

LongCount<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<long> LongCount<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<System.Int64>
Type Parameters
Name Description
T
| Improve this Doc View Source

LongCountExt<TEntity>(IEnumerable<TEntity>, Func<TEntity, Nullable<Object>>)

Declaration
public static long LongCountExt<TEntity>(this IEnumerable<TEntity> source, Func<TEntity, object?> expr)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, System.Nullable<System.Object>> expr
Returns
Type Description
System.Int64
Type Parameters
Name Description
TEntity
| Improve this Doc View Source

LongCountExt<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

Declaration
public static long LongCountExt<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Sql.AggregateModifier modifier
Returns
Type Description
System.Int64
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

LongCountExt<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

Declaration
public static long LongCountExt<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier = Sql.AggregateModifier.None)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Sql.AggregateModifier modifier
Returns
Type Description
System.Int64
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Max<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Max<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Max<T>(Sql.ISqlExtension, T, Sql.AggregateModifier)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Max<T>(this Sql.ISqlExtension ext, T expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Sql.AggregateModifier modifier
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Max<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

Declaration
public static TV Max<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Sql.AggregateModifier modifier
Returns
Type Description
TV
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Max<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

Declaration
public static TV Max<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Sql.AggregateModifier modifier
Returns
Type Description
TV
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Median<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.IReadyToFunctionOrOverWithPartition<T> Median<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IReadyToFunctionOrOverWithPartition<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Median<TEntity, T>(IEnumerable<TEntity>, Func<TEntity, T>)

Declaration
public static long Median<TEntity, T>(this IEnumerable<TEntity> source, Func<TEntity, T> expr)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, T> expr
Returns
Type Description
System.Int64
Type Parameters
Name Description
TEntity
T
| Improve this Doc View Source

Median<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

Declaration
public static long Median<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Returns
Type Description
System.Int64
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Min<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Min<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Min<T>(Sql.ISqlExtension, T, Sql.AggregateModifier)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Min<T>(this Sql.ISqlExtension ext, T expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Sql.AggregateModifier modifier
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Min<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

Declaration
public static TV Min<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Sql.AggregateModifier modifier
Returns
Type Description
TV
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Min<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

Declaration
public static TV Min<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Sql.AggregateModifier modifier
Returns
Type Description
TV
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

NthValue<T>(Sql.ISqlExtension, T, Int64)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> NthValue<T>(this Sql.ISqlExtension ext, T expr, long n)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
System.Int64 n
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

NthValue<T>(Sql.ISqlExtension, T, Int64, Sql.From, Sql.Nulls)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> NthValue<T>(this Sql.ISqlExtension ext, T expr, long n, Sql.From from, Sql.Nulls nulls)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
System.Int64 n
Sql.From from
Sql.Nulls nulls
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

NTile<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> NTile<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

PercentileCont<T>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.INeedsWithinGroupWithSingleOrderAndMaybePartition<T> PercentileCont<T>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedsWithinGroupWithSingleOrderAndMaybePartition<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

PercentileDisc<T>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.INeedsWithinGroupWithSingleOrderAndMaybePartition<T> PercentileDisc<T>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedsWithinGroupWithSingleOrderAndMaybePartition<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

PercentRank<T>(Sql.ISqlExtension)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> PercentRank<T>(this Sql.ISqlExtension ext)
Parameters
Type Name Description
Sql.ISqlExtension ext
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

PercentRank<T>(Sql.ISqlExtension, Nullable<Object>[])

Declaration
public static AnalyticFunctions.INeedsWithinGroupWithOrderOnly<T> PercentRank<T>(this Sql.ISqlExtension ext, params object? [] expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object>[] expr
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedsWithinGroupWithOrderOnly<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Rank(Sql.ISqlExtension)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<long> Rank(this Sql.ISqlExtension ext)
Parameters
Type Name Description
Sql.ISqlExtension ext
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<System.Int64>
| Improve this Doc View Source

Rank(Sql.ISqlExtension, Nullable<Object>[])

Declaration
public static AnalyticFunctions.INeedsWithinGroupWithOrderOnly<long> Rank(this Sql.ISqlExtension ext, params object? [] expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object>[] expr
Returns
Type Description
LinqToDB.AnalyticFunctions.INeedsWithinGroupWithOrderOnly<System.Int64>
| Improve this Doc View Source

RatioToReport<TR>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.IOverWithPartitionNeeded<TR> RatioToReport<TR>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IOverWithPartitionNeeded<TR>
Type Parameters
Name Description
TR
| Improve this Doc View Source

RegrAvgX<T>(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrAvgX<T>(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

RegrAvgY<T>(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrAvgY<T>(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

RegrCount(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<long> RegrCount(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<System.Int64>
| Improve this Doc View Source

RegrIntercept<T>(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrIntercept<T>(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

RegrR2<T>(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrR2<T>(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

RegrSlope<T>(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrSlope<T>(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

RegrSXX<T>(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrSXX<T>(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

RegrSXY<T>(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrSXY<T>(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

RegrSYY<T>(Sql.ISqlExtension, Nullable<Object>, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrSYY<T>(this Sql.ISqlExtension ext, object? expr1, object? expr2)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr1
System.Nullable<System.Object> expr2
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

RowNumber(Sql.ISqlExtension)

Declaration
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<long> RowNumber(this Sql.ISqlExtension ext)
Parameters
Type Name Description
Sql.ISqlExtension ext
Returns
Type Description
LinqToDB.AnalyticFunctions.IAnalyticFunctionWithoutWindow<System.Int64>
| Improve this Doc View Source

StdDev<T>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> StdDev<T>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

StdDev<T>(Sql.ISqlExtension, Nullable<Object>, Sql.AggregateModifier)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> StdDev<T>(this Sql.ISqlExtension ext, object? expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Sql.AggregateModifier modifier
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

StdDev<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

Declaration
public static double StdDev<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Returns
Type Description
System.Double
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

StdDev<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

Declaration
public static double StdDev<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Sql.AggregateModifier modifier
Returns
Type Description
System.Double
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

StdDev<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

Declaration
public static double StdDev<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier = Sql.AggregateModifier.None)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Sql.AggregateModifier modifier
Returns
Type Description
System.Double
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

StdDevPop<T>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> StdDevPop<T>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

StdDevPop<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

Declaration
public static decimal StdDevPop<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

StdDevPop<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

Declaration
public static decimal StdDevPop<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

StdDevSamp<T>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> StdDevSamp<T>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

StdDevSamp<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

Declaration
public static decimal StdDevSamp<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

StdDevSamp<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

Declaration
public static decimal StdDevSamp<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Sum<T>(Sql.ISqlExtension, T)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Sum<T>(this Sql.ISqlExtension ext, T expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Sum<T>(Sql.ISqlExtension, T, Sql.AggregateModifier)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Sum<T>(this Sql.ISqlExtension ext, T expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
Sql.ISqlExtension ext
T expr
Sql.AggregateModifier modifier
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Variance<T>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Variance<T>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Variance<T>(Sql.ISqlExtension, Nullable<Object>, Sql.AggregateModifier)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Variance<T>(this Sql.ISqlExtension ext, object? expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Sql.AggregateModifier modifier
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Variance<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

Declaration
public static TV Variance<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Returns
Type Description
TV
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Variance<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

Declaration
public static TV Variance<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Sql.AggregateModifier modifier
Returns
Type Description
TV
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

Variance<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

Declaration
public static TV Variance<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier = Sql.AggregateModifier.None)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Sql.AggregateModifier modifier
Returns
Type Description
TV
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

VarPop<T>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> VarPop<T>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

VarPop<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

Declaration
public static decimal VarPop<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

VarPop<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

Declaration
public static decimal VarPop<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

VarSamp<T>(Sql.ISqlExtension, Nullable<Object>)

Declaration
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> VarSamp<T>(this Sql.ISqlExtension ext, object? expr)
Parameters
Type Name Description
Sql.ISqlExtension ext
System.Nullable<System.Object> expr
Returns
Type Description
LinqToDB.AnalyticFunctions.IAggregateFunctionSelfContained<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

VarSamp<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

Declaration
public static decimal VarSamp<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
Parameters
Type Name Description
IEnumerable<TEntity> source
Func<TEntity, TV> expr
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
TV
| Improve this Doc View Source

VarSamp<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

Declaration
public static decimal VarSamp<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
Parameters
Type Name Description
IQueryable<TEntity> source
Expression<Func<TEntity, TV>> expr
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TEntity
TV