SelectQuery.AddRelation(Table, Table, SqlJoinType, RelationColumnInfo[]) Method

Creates a relation between two data tables. Allows you to specify the join operation type and columns relations that should be used to join the tables.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v23.2.dll

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

Declaration

C#

public Join AddRelation(
    Table parent,
    Table nested,
    SqlJoinType joinType,
    params RelationColumnInfo[] keyColumns
)

VB.NET

Public Function AddRelation(
    parent As Table,
    nested As Table,
    joinType As SqlJoinType,
    ParamArray keyColumns As RelationColumnInfo()
) As Join

Parameters

Name	Type	Description
parent	Table	A parent table.
nested	Table	A nested table.
joinType	SqlJoinType	The join operation type.
keyColumns	RelationColumnInfo[]	An array of columns relations.

Returns

Type	Description
Join	A relation between two data tables.