Skip to main content

SelectQueryFluentBuilder.SortBy(String, AggregationType, ListSortDirection) Method

Sorts the result set by a specified column in a required direction by applying an aggregate function. This column is obtained from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

public SelectQueryFluentBuilder SortBy(
    string columnName,
    AggregationType aggregate,
    ListSortDirection direction
)

Parameters

Name Type Description
columnName String

A String value, specifying the column name.

aggregate AggregationType

An AggregationType enumeration value.

direction ListSortDirection

A ListSortDirection enumeration value.

Returns

Type Description
SelectQueryFluentBuilder

A SelectQueryFluentBuilder object.

See Also