Click or drag to resize

AggregateFunction Enumeration

Enum definition for the various aggregate functions which can be applied to fields in a retrieval query. Useful in typed lists. Use these in combination with a groupbycollection. Not all functions are legal on all fields. Some functions will produce errors when used with fields of a given type, like a Sum function with a character field. This is the responsibility of the developer. Aggregate functions are never applied to *lob fields.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.4.0.0 (5.4.0)
Syntax
public enum AggregateFunction
Members
  Member nameValueDescription
None0 Default, do not apply an aggregate function to the field.
Count1 Calculates the amount of rows for the field. Results in COUNT(field)
CountDistinct2 Calculates the amount of rows with distinct values for field. Results in COUNT(DISTINCT field). Access, MySql: not supported
CountRow3 Calculates the amount of rows. Results in a COUNT(*)
CountBig4 Calculates the amount of rows for the field. Results in COUNT(field) and returns an Int64. SQL Server 2005+
CountBigDistinct5 Calculates the amount of rows with distinct values for field. Results in COUNT(DISTINCT field) and returns an Int64. SQL Server 2005+ Access, MySql: not supported
CountBigRow6 Calculates the amount of rows. Results in a COUNT(*) and returns an Int64. SQL Server 2005+
Avg7 Calculates the average value for the field. Results in an AVG(field)
AvgDistinct8 Calculates the average value for the distinct values for field. Results in an AVG(DISTINCT field). Access, MySql: not supported
Max9 Calculates the max value for field. Results in a MAX(field).
Min10 Calculates the min value for field. Results in a MIN(field)
Sum11 Calculates the sum of all values of field. Results in a SUM(field)
SumDistinct12 Calculates the sum of all distinct values of field. Results in a SUM(DISTINCT field). Access, MySql: not supported
StDev13 Calculates statistical standard deviation. Results in: SqlServer: STDEV(field)
Oracle, MySql: STDDEV(field)
Access: STDEV(field)
Firebird: not supported
StDevDistinct14 Calculates statistical standard deviation over distinct values. Results in: SqlServer: not supported
Oracle: STDDEV(DISTINCT field)
Access, Firebird, MySql: not supported
Variance15 Calculates statistical variance. Results in: SqlServer: VAR(field)
Oracle, MySql: VARIANCE(field)
Access: VAR(field)
Firebird: not supported.
VarianceDistinct16 Calculates statistical variance over distinct values. Results in: SqlServer: not supported
Oracle: VARIANCE(DISTINCT field)
Access, Firebird, MySql: not supported
See Also