Click or drag to resize

AggregateSetFunction Enumeration

Enum definition for the various aggregate functions supported by the AggregateSetPredicate for in-memory filters.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.11.0.0 (5.11.23.1114)
Syntax
public enum AggregateSetFunction
Members
  Member nameValueDescription
Count0 Calculates the amount of elements matching the specified filter. Result is of type Int32
CountDistinct1 Calculates the amount of elements matching the specified filter, ignoring duplicates. Result is of type Int32. NULL/DBNull.Value is counted as a value.
Avg2 Calculates the average value for the values in the set. Result is of type Decimal.
AvgDistinct3 Calculates the average value for the values in the set, excluding duplicates. Result is of type Decimal
Max4 Calculates the max value for the values in the set. Result is of the type of the values in the set.
Min5 Calculates the min value for the values in the set. Result is of the type of the values in the set.
Sum6 Calculates the sum of all values in the set. Result is of the type of the values in the set.
SumDistinct7 Calculates the sum of all values in the set excluding duplicates. Result is of the type of the values in the set.
See Also