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

Creates a relation between two data tables using a specified join operation and logical condition.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v20.2.dll

Declaration

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

Parameters

Name Type Description
parent Table

A Table object, specifying the parent table.

nested Table

A Table object, specifying the nested table.

joinType JoinType

A JoinType enumeration value, specifying the data relation.

parentKeyColumn String

A String value, specifying the parent key column name.

nestedKeyColumn String

A String value, specifying the nested key column name.

compareOperator ConditionType

A ConditionType enumeration value.

Returns

Type Description
Join

A Join object.

See Also