AggregationType Enum

Lists values that specify aggregation types.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v17.2.dll

Declaration

C#

public enum AggregationType

VB.NET

Public Enum AggregationType

Members

Name	Description
None	Aggregation is not applied.
Count	The number of values.
Max	The largest value.
Min	The smallest value.
Avg	The average of the values.
Sum	The sum of the values.
CountDistinct	The number of different values.
AvgDistinct	The average of different values.
SumDistinct	The sum of different values.

Related API Members

The following properties accept/return AggregationType values:

• ColumnInfo.Aggregation
• ExpressionBase.Aggregate

Remarks

Values listed in this enumeration are used to set the ColumnInfo.Aggregation property.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the AggregationType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-create-data-access-library-data-sources-at-runtime-t424210/CS/SqlDataSourceSnippets/Code.cs#L30

.Join("Products", "CategoryID")
.SelectColumn("ProductName", AggregationType.Count, "ProductCount")
.SortBy("ProductName", AggregationType.Count, System.ComponentModel.ListSortDirection.Descending)

Reporting_how-to-programmatically-bind-a-report-to-an-mdb-file-using-a-selectquery-t437883/CS/RuntimeBindingToMdbDatabase/Form1.cs#L33

.Join("Products", "CategoryID")
.SelectColumn("ProductName", AggregationType.Count, "ProductCount")
.SortBy("ProductName", AggregationType.Count, System.ComponentModel.ListSortDirection.Descending)

VB.NET

how-to-create-data-access-library-data-sources-at-runtime-t424210/VB/SqlDataSourceSnippets/Code.vb#L21

Private Sub SelectQueryCreation()
    Dim query As SelectQuery = SelectQueryFluentBuilder.AddTable("Categories").SelectColumn("CategoryName").GroupBy("CategoryName").Join("Products", "CategoryID").SelectColumn("ProductName", AggregationType.Count, "ProductCount").SortBy("ProductName", AggregationType.Count, System.ComponentModel.ListSortDirection.Descending).GroupFilter("[ProductCount] > 7").Build("Categories")
    DataSource.Queries.Add(query)

Reporting_how-to-programmatically-bind-a-report-to-an-mdb-file-using-a-selectquery-t437883/VB/RuntimeBindingToMdbDatabase/Form1.vb#L30

' The chain ends with calling the Build method accepting the query name as a parameter.
Dim query As SelectQuery = SelectQueryFluentBuilder.AddTable("Categories").SelectColumn("CategoryName").GroupBy("CategoryName").Join("Products", "CategoryID").SelectColumn("ProductName", AggregationType.Count, "ProductCount").SortBy("ProductName", AggregationType.Count, System.ComponentModel.ListSortDirection.Descending).GroupFilter("[ProductCount] > 7").Build("selectQuery")