SelectQueryFluentBuilder.Join(String, String, SqlJoinType, String, String) Method

Joins two tables. Allows you to specify a table alias, the join operation type, and column names by which the tables should be joined.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v21.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.Design

Declaration

C#

public SelectQueryFluentBuilder Join(
    string tableName,
    string tableAlias,
    SqlJoinType joinType,
    string parentColumnName,
    string nestedColumnName
)

VB.NET

Public Function Join(
    tableName As String,
    tableAlias As String,
    joinType As SqlJoinType,
    parentColumnName As String,
    nestedColumnName As String
) As SelectQueryFluentBuilder

Parameters

Name	Type	Description
tableName	String	The name of the table (nested table) with which the current table (parent table) of the query builder should be joined.
tableAlias	String	A table alias.
joinType	SqlJoinType	The join operation type.
parentColumnName	String	The parent table column name.
nestedColumnName	String	The nested table column name.

Returns

Type	Description
SelectQueryFluentBuilder	A query builder object that contains the join operation result.

Example

C#

using DevExpress.DataAccess.Sql;
// ...
var query = SelectQueryFluentBuilder
    .AddTable("Categories")
    .SelectColumns("CategoryName", "CategoryID")
    .Join(tableName: "Products",
        tableAlias: "Products1",
        joinType: SqlJoinType.Inner,
        parentColumnName: "CategoryID",
        nestedColumnName: "CtgID")
    .SelectColumn("ProductName")
    .Join(tableName: "Products",
        joinType: SqlJoinType.LeftOuter,
        keyColumnName: "ProductName")
    .SelectColumn("UnitPrice")
    .Build("Categories");

VB.NET

Imports DevExpress.DataAccess.Sql
' ...
Dim query = SelectQueryFluentBuilder.
    AddTable("Categories").
    SelectColumns("CategoryName", "CategoryID").
    Join(tableName:="Products",
         tableAlias:="Products1",
         joinType:=SqlJoinType.Inner,
         parentColumnName:="CategoryID",
         nestedColumnName:="CtgID").
    SelectColumn("ProductName").
    Join(tableName:="Products",
         joinType:=SqlJoinType.LeftOuter,
         keyColumnName:="ProductName").
    SelectColumn("UnitPrice").
    Build("Categories")