SelectQueryFluentBuilder.Build(String) Method

Ends the chain of methods specified for a SelectQueryFluentBuilder.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v20.2.dll


public SelectQuery Build(
    string queryName
Public Function Build(
    queryName As String
) As SelectQuery


Name Type Description
queryName String

A String value, specifying the query name.


Type Description

A SelectQuery object.


The chain of SelectQueryFluentBuilder methods must end with calling the Build method accepting the query name as a parameter.

In the following example, a query selects and orders records from a single data table.

using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
// ... 

private SqlDataSource BindToData() {
    // Create a data source with the required connection parameters. 
    Access97ConnectionParameters connectionParameters =
    new Access97ConnectionParameters("../../Data/nwind.mdb", "", "");
    SqlDataSource ds = new SqlDataSource(connectionParameters);

    // Return a list of categories sorted by the number of products in each category. 
    // The chain ends with calling the Build method accepting the query name as a parameter.
    SelectQuery query = SelectQueryFluentBuilder
        .SortBy("ProductID", AggregationType.Count, System.ComponentModel.ListSortDirection.Descending)
        .Filter("[CategoryID] != 8")

    // Add the query to the collection and return the data source. 
    return ds;
See Also