FederationDataSource.Relations Property

Provides access to the collection of the FederationMasterDetailInfo objects that define master-detail relationships.

Namespace: DevExpress.DataAccess.DataFederation

Assembly: DevExpress.DataAccess.v23.2.dll

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

Declaration

C#

public MasterDetailInfoCollection Relations { get; }

VB.NET

Public ReadOnly Property Relations As MasterDetailInfoCollection

Property Value

Type	Description
MasterDetailInfoCollection	A collection of master-detail relationships.

Example

To create a master-detail relationship between two queries, add an instance of the FederationMasterDetailInfo object to the Relations collection:

Note

The complete sample project How to Create a Federated Data Source at Runtime is available in the DevExpress Examples repository.

C#

using DevExpress.DataAccess.DataFederation;
// ...
  federation.Relations.Add(new FederationMasterDetailInfo() {
      MasterQueryName = "Orders",
      DetailQueryName = "OrderDetail",
      KeyColumns = {
          new FederationRelationColumnInfo(){
              ParentKeyColumn="OrderID",
              NestedKeyColumn ="OrderID",
              ConditionOperator= FederationConditionType.Equal
              }
          }
  }

VB.NET

Imports DevExpress.DataAccess.DataFederation
' ... 
  federation.Relations.Add(
      New FederationMasterDetailInfo("Orders",
                                      "OrderDetail", 
                                      New FederationRelationColumnInfo() With
                                      {.ParentKeyColumn = "OrderID",
                                      .NestedKeyColumn = "OrderID",
                                      .ConditionOperator = FederationConditionType.Equal}))