SelectQuery.AddRelation(Table, Table, SqlJoinType, String, String, ConditionType) Method

Creates a relation between two data tables. Allows you to specify the join operation type, table column names that should be used in the join operation, and the relational operator type that should be used to compare column values.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.1.dll

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

Declaration

C#

public Join AddRelation(
    Table parent,
    Table nested,
    SqlJoinType joinType,
    string parentKeyColumn,
    string nestedKeyColumn,
    ConditionType compareOperator
)

VB.NET

Public Function AddRelation(
    parent As Table,
    nested As Table,
    joinType As SqlJoinType,
    parentKeyColumn As String,
    nestedKeyColumn As String,
    compareOperator As ConditionType
) As Join

Parameters

Name	Type	Description
parent	Table	A parent table.
nested	Table	A nested table.
joinType	SqlJoinType	The join operation type.
parentKeyColumn	String	The parent table column name.
nestedKeyColumn	String	The nested table column name.
compareOperator	ConditionType	The relational operator type.

Returns

Type	Description
Join	A relation between two data tables.