combit List & Label 24 - .NET Online Web Help
AddCrossProviderRelation Method


combit.ListLabel24.DataProviders Namespace > DataProviderCollection Class : AddCrossProviderRelation Method

Name of the relation

Dataprovider from which the parent table is used

Name of the parent table

Name of the parent column

Dataprovider from which the child table is used

Name of the child table

Name of the child column

Creates a (virtual) 1:n relation between two tables from this collection of data providers. The tables may belong to different data providers or to the same data provider. Please note that the support for custom relations depends on the capabilities of the involved data providers.


Any table of any data provider type can be specified as the parent table (primary key table). However only a table that supports filtering can be specified as the child table (table containing the foreign key). The support for filtering depends on the type of the data provider and may be tested with the SupportsFiltering property of a table object. Only when the parent table also supports filtering (this is optional), a 1:1 relation from rows of the child table to a row of the parent table will be offered in the Designer.

Internally, the data providers (or the database system that they are connected to) will need to compare the values of the specified parent/child columns. List & Label does not check if the data types of the parent/child columns can be compared. Therefore we recommend to only define relations on columns of the same data type.


See the remarks section for more information on supported data provider types.

Syntax

Parameters

relationName

Name of the relation

parentProvider

Dataprovider from which the parent table is used

parentTableName

Name of the parent table

parentColumnName

Name of the parent column

childProvider

Dataprovider from which the child table is used

childTableName

Name of the child table

childColumnName

Name of the child column

Exceptions
ExceptionDescription
Thrown when the parentProvider or the childProvider are not contained in this data provider code, or when the child table does not support filtering.
Remarks

Filterable data providers that can be used as the parent or the child table:
All SQL-based databases (SQL Server, Oracle, MySQL, ...), OData, ODBC, OLE DB, MongoDB, Cassandra, Salesforce


Filterable when wrapped with the InMemoryDataProvider:
CSV, Excel


Unfilterable data providers that can be used only as parent table:
REST, JSON, XML, Google Analytics, Google BigQuery, Google Spreadsheet

Requirements

Platforms: Windows Vista - Windows 10 Version 1809, Windows Server 2008 - 2016

See Also

Reference

DataProviderCollection Class
DataProviderCollection Members