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

C#

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

VB.NET

Public Function SortBy(
    columnName As String,
    aggregate As AggregationType,
    direction As ListSortDirection
) As SelectQueryFluentBuilder

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.