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

Creates a relation between two data tables using an inner join operation.

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,
    params RelationColumnInfo[] keyColumns
)

VB.NET

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

Parameters

Name	Type	Description
parent	Table	A Table object, specifying the parent table.
nested	Table	A Table object, specifying the nested table.
keyColumns	RelationColumnInfo[]	An array of RelationColumnInfo objects.

Returns

Type	Description
Join	A Join object.