Skip to main content
All docs
V24.1

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.v24.1.dll

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

Declaration

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

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.

See Also