Entities Data Model
The Entities Data Model defines, stores, and manages structured data within business applications. It enables data relationships, security, automation, and integration with Microsoft Power Platform, Dynamics 365, and external systems.
Views
The Views section, which lists read-only SQL tables, contain samples of what you may have access to in your Microsoft Dataverse account.
The following views are shipped with the driver:
| Table | Description |
| MultiSelectPickListAttributeMetaData | Stores metadata for attributes that support MultiSelect OptionSet, defining the structure and behavior of multi-option fields. |
| MultiSelectPickListOptions | Contains the possible selectable options for MultiSelect OptionSet attributes, enabling multi-value selections. |
| PickListAttributeMetaData | Holds metadata for attributes of type Picklist, describing the single-option selection fields in the system. |
| PickListOptions | Defines the set of selectable options available for Picklist attributes, supporting user-defined field values. |
| StateAttributeMetadata | Provides metadata for attributes of type State, describing state-related fields used for status tracking or categorization. |
| StateAttributeOptions | Lists the selectable states available for State attributes, representing various predefined states. |
| StatusAttributeMetadata | Contains metadata for attributes of type Status, often used to track the lifecycle or current condition of an entity. |
| StatusAttributeOptions | Defines the set of statuses that can be assigned to Status attributes, supporting status-driven workflows. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including retrieving and refreshing the OAuth Access Token.