SelectQuery.AddRelation(Table, Table, String) Method

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

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 keyColumn
)

VB.NET

Public Function AddRelation(
    parent As Table,
    nested As Table,
    keyColumn As String
) As Join

Parameters

Name	Type	Description
parent	Table	A Table object, specifying the parent table.
nested	Table	A Table object, specifying the nested table.
keyColumn	String	A String value, specifying the key column name.

Returns

Type	Description
Join	A Join object.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the AddRelation(Table, Table, String) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-bind-dashboard-to-sql-server-database-file/CS/BindToMsSqlDatabaseFileExample/Form1.cs#L66

var categories = selectQuery.AddTable("Categories");
selectQuery.AddRelation(order_details, orders, "OrderID");
selectQuery.AddRelation(orders, employees, "EmployeeID");

VB.NET

how-to-bind-dashboard-to-sql-server-database-file/VB/BindToMsSqlDatabaseFileExample/Form1.vb#L56

Dim categories = selectQuery.AddTable("Categories")
selectQuery.AddRelation(order_details, orders, "OrderID")
selectQuery.AddRelation(orders, employees, "EmployeeID")