SelectNodeBuilder.Build(String) Method

Finalizes the chain of methods specified to build a SelectNode and returns the SelectNode with the specified alias.

Namespace: DevExpress.DataAccess.DataFederation

Assembly: DevExpress.DataAccess.v24.1.dll

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

Declaration

C#

public SelectNode Build(
    string alias
)

VB.NET

Public Function Build(
    alias As String
) As SelectNode

Parameters

Name	Type	Description
alias	String	A string that is the alias for the created SelectNode.

Returns

Type	Description
SelectNode	The SelectNode object created with the SelectNodeBuilder.

Remarks

This method finalizes the chain of methods used in FluentAPI to create a SelectNode object and returns the SelectNode object with the specified alias.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Build(String) method.

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#

create-a-federated-data-source-at-runtime/CS/FederationDataSourceExample/FederationDataSourceHelper.cs#L85

SelectNode query1 = sourceProducts.From().Select("ProductName", "QuantityPerUnit", "UnitsInStock")
    .Join(sourceOrderDetail, "[Products.ProductName] = [OrderDetail.ProductName]")

Reporting-Bind-Report-To-Federated-Master-Detail-Data-Source/CS/Form1.cs#L38

// Create the federated "Categores" query and select data from the SQL source's query.
var categoriesNode = sqlSource.From()
    .Select("CategoryID", "CategoryName", "Description").Build("Categories");

data-access-library-create-data-sources-at-runtime/CS/FederationDataSourceSnippets/Code.cs#L21

// Create a federated query.
var selectNode = sqlSource.From()
    // Select the "CategoryName" column from the SQL source.

winforms-dashboard-data-federation/CS/DataFederationExample/Form1.cs#L89

SelectNode mainQueryCreatedByNodeBuilder =
    sqlSource.From()
    .Select("OrderDate", "ShipCity", "ShipCountry")

reporting-winforms-bind-join-federated-data-source/CS/Form1.cs#L39

// Create a federated query.
var selectNode = sqlSource.From()
    // Select the "CategoryName" column from the SQL source.

VB.NET

create-a-federated-data-source-at-runtime/VB/FederationDataSourceExample/FederationDataSourceHelper.vb#L66

Dim query1 As SelectNode = sourceProducts.From().Select("ProductName", "QuantityPerUnit", "UnitsInStock").Join(sourceOrderDetail, "[Products.ProductName] = [OrderDetail.ProductName]").Select("OrderDate").Build("ProductsOrderDetail")

Reporting-Bind-Report-To-Federated-Master-Detail-Data-Source/VB/Form1.vb#L40

' Create the federated "Categores" query and select data from the SQL source's query.
Dim categoriesNode = sqlSource.From().Select("CategoryID", "CategoryName", "Description").Build("Categories")
' Create the federated "Products" query and select data from the Excel data source.

data-access-library-create-data-sources-at-runtime/VB/FederationDataSourceSnippets/Code.vb#L18

' Create a federated query.
Dim selectNode = sqlSource.From().Select("CategoryName").Join(excelSource, "[Excel_Products.CategoryID] = [Sql_Categories.CategoryID]").Select("CategoryID", "ProductName", "UnitPrice").Build("CategoriesProducts")
    ' Select the "CategoryName" column from the SQL source.

winforms-dashboard-data-federation/VB/DataFederationExample/Form1.vb#L91

#Region "Use NodedBuilder to join SQL, Excel, and Object Data Sources in a Query"
Dim mainQueryCreatedByNodeBuilder As SelectNode = sqlSource.From().Select("OrderDate", "ShipCity", "ShipCountry").Join(excelSource, "[excel.OrderID] = [sqlite.OrderID]").Select("CategoryName", "ProductName", "Extended Price").Join(objectSource, "[object.SalesPerson] = [excel.Sales Person]").Select("SalesPerson", "Weight").Build("FDS-Created-by-NodeBulder")
#End Region

reporting-winforms-bind-join-federated-data-source/VB/Form1.vb#L41

' Create a federated query.
Dim selectNode = sqlSource.From().Select("CategoryName").Join(excelSource, "[Excel_Products.CategoryID] = [Sql_Categories.CategoryID]").Select("CategoryID", "ProductName", "UnitPrice").Build("CategoriesProducts")
    ' Select the "CategoryName" column from the SQL source.