Skip to main content
All docs
V24.1

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

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

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.

See Also