SqlDataSource.Relations Property

Provides access to the collection of master-detail relations of the SqlDataSource.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v23.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

[LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)]
public MasterDetailInfoCollection Relations { get; }

VB.NET

<LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)>
Public ReadOnly Property Relations As MasterDetailInfoCollection

Property Value

Type	Description
MasterDetailInfoCollection	A MasterDetailInfoCollection object.

Remarks

To add a relationship between two tables, add a MasterDetailInfo instance to the SqlDataSource.Relations collection:

C#

using DevExpress.DataAccess.Sql;
using DevExpress.DataAccess.ConnectionParameters;
// ...
void AddQueryRelations()
{
    SelectQuery categories = SelectQueryFluentBuilder
        .AddTable("Categories")
        .SelectAllColumns()
        .Build("Categories");
    SelectQuery products = SelectQueryFluentBuilder
        .AddTable("Products")
        .SelectAllColumns()
        .Build("Products");

    DataSource.Queries.AddRange(new SqlQuery[] { categories, products });
    DataSource.Relations.Add(
        new MasterDetailInfo("Categories", "Products", "CategoryID", "CategoryID"));
}

VB.NET

Imports DevExpress.DataAccess.Sql
Imports DevExpress.DataAccess.ConnectionParameters
' ...
Private Sub AddQueryRelations()
    Dim categories As SelectQuery = SelectQueryFluentBuilder.
        AddTable("Categories").
        SelectAllColumns().Build("Categories")
    Dim products As SelectQuery = SelectQueryFluentBuilder.
        AddTable("Products").
        SelectAllColumns().Build("Products")

    DataSource.Queries.AddRange(New SqlQuery() { categories, products })
    DataSource.Relations.Add(New MasterDetailInfo("Categories", "Products", "CategoryID", "CategoryID"))
End Sub

For more information, review the following help topic: Manage Table Relations.

The full code is available in the sample application:

View Example: How to Create a Report Bound to the SQL Data Source