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.v18.2.dll

Declaration

C#

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

VB.NET

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.