Class SqlNode.AggregateFunctions

Namespace

LfrlAnvil.Sql.Expressions

Assembly

LfrlAnvil.Sql.Core.dll

Creates instances of SqlAggregateFunctionExpressionNode type.

public static class SqlNode.AggregateFunctions

Inheritance

object

SqlNode.AggregateFunctions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Methods

Average(SqlExpressionNode)

Creates a new SqlAverageAggregateFunctionExpressionNode instance.

[Pure]
public static SqlAverageAggregateFunctionExpressionNode Average(SqlExpressionNode argument)

Parameters

argument SqlExpressionNode

Expression to calculate the average value for.

Returns

SqlAverageAggregateFunctionExpressionNode

New SqlAverageAggregateFunctionExpressionNode instance.

Count(SqlExpressionNode)

Creates a new SqlCountAggregateFunctionExpressionNode instance.

[Pure]
public static SqlCountAggregateFunctionExpressionNode Count(SqlExpressionNode argument)

Parameters

argument SqlExpressionNode

Expression to calculate the number of records for.

Returns

SqlCountAggregateFunctionExpressionNode

New SqlCountAggregateFunctionExpressionNode instance.

Max(SqlExpressionNode)

Creates a new SqlMaxAggregateFunctionExpressionNode instance.

[Pure]
public static SqlMaxAggregateFunctionExpressionNode Max(SqlExpressionNode argument)

Parameters

argument SqlExpressionNode

Expression to calculate the maximum value for.

Returns

SqlMaxAggregateFunctionExpressionNode

New SqlMaxAggregateFunctionExpressionNode instance.

Min(SqlExpressionNode)

Creates a new SqlMinAggregateFunctionExpressionNode instance.

[Pure]
public static SqlMinAggregateFunctionExpressionNode Min(SqlExpressionNode argument)

Parameters

argument SqlExpressionNode

Expression to calculate the minimum value for.

Returns

SqlMinAggregateFunctionExpressionNode

New SqlMinAggregateFunctionExpressionNode instance.

Named(SqlSchemaObjectName, params SqlExpressionNode[])

Creates a new SqlNamedAggregateFunctionExpressionNode instance.

[Pure]
public static SqlNamedAggregateFunctionExpressionNode Named(SqlSchemaObjectName name, params SqlExpressionNode[] arguments)

Parameters

name SqlSchemaObjectName

Aggregate function's name.

arguments SqlExpressionNode[]

Collection of aggregate function's arguments.

Returns

SqlNamedAggregateFunctionExpressionNode

New SqlNamedAggregateFunctionExpressionNode instance.

StringConcat(SqlExpressionNode, SqlExpressionNode?)

Creates a new SqlStringConcatAggregateFunctionExpressionNode instance.

[Pure]
public static SqlStringConcatAggregateFunctionExpressionNode StringConcat(SqlExpressionNode argument, SqlExpressionNode? separator = null)

Parameters

argument SqlExpressionNode

Expression to calculate the concatenated string for.

separator SqlExpressionNode

Optional separator of concatenated strings. Equal to null by default.

Returns

SqlStringConcatAggregateFunctionExpressionNode

New SqlStringConcatAggregateFunctionExpressionNode instance.

Sum(SqlExpressionNode)

Creates a new SqlSumAggregateFunctionExpressionNode instance.

[Pure]
public static SqlSumAggregateFunctionExpressionNode Sum(SqlExpressionNode argument)

Parameters

argument SqlExpressionNode

Expression to calculate the sum value for.

Returns

SqlSumAggregateFunctionExpressionNode

New SqlSumAggregateFunctionExpressionNode instance.