The CData ADO.NET Provider for Microsoft Dynamics 365 Business Central models Microsoft Dynamics 365 Business Central data in relational tables, views, and stored procedures. The table definitions are dynamically obtained from the Microsoft Dynamics 365 Business Central OData service when you connect. Any changes to the metadata, such as new or removed columns, or changes in data type, are automatically loaded when you reconnect.

Tables

The provider models the writable entities described in the service metadata document as bidirectional Tables.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, such as retrieving or refreshing OAuth access tokens.

Known Limitations

Sometimes, the Business Central OData API will provide incorrect values for the edm:maxLength property facet, when fetching metadata. This data is used when reporting the sys_tablecolumns.Length column.

This typically affects columns which follow the AuxiliaryIndex{DIGIT} pattern in their names. For example:

• AuxiliaryIndex1
• AuxiliaryIndex2

If your client is affected by the incorrect sys_tablecolumns.Length reported by the provider, we suggest using CreateSchema to create the table's schema file. With the table schema file available, you can correct the Length property by modifying the columnSize attribute:

<attr name="AuxiliaryIndex1" columnSize="100" ... />

Another workaround is to use the MinimumColumnSize connection property.