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

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

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,
    string parentKeyColumn,
    string nestedKeyColumn,
    ConditionType compareOperator
)

VB.NET

Public Function AddRelation(
    parent As Table,
    nested As Table,
    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.
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.