Send feedback on this topic.
Teradata.Client.Provider
Entity Provider Store Schemas
.NET Data Provider for Teradata > Developer's Guide > ADO.NET Entity Provider for Teradata > Entity Provider Store Schemas
.NET CORE   This feature is not supported by the .NET Core implementation of the Data Provider.

Store Schema Information is retrieved by accessing the Data Dictionary views. Two versions of the system views are available -- an X and non-X version. The version accessed is based on the UseXViews Connection String attribute. Refer to Store Schema Limitations for information on limitations related to UseXViews.

The Views and bViewColumns are not supported by the Entity Provider for Teradata before 13.11. The primary reason for this is that information required by the ViewColumns store schemas cannot be retrieved using the Teradata Data Dictionary without pre-processing the data. The information for the Views store schema can be retrieved from the Teradata Data Dictionary. However, the Views and ViewColumns are closely related so both store schemas were not supported. Refer to The Views and ViewColumns Problem for a more detailed discussion on this problem.

Starting with the .NET Data Provider for Teradata 13.11, these two store schemas are supported. The Views and ViewColumns store schemas must be mapped to tables. These tables must be loaded with their corresponding schema information using the SchemaLoader utility, and mapping information must be added to the application configuration file. For more information refer to Mapping Views and ViewColumns to Tables.

For more information on the System Views refer to the Data Dictionary manual.

In This Section

List of Store Schemas

Mapping Views and ViewColumns to Tables

Limitations When Using Store Schemas