Before upgrading to .NET Data Provider for Teradata version 13.0.0.1, please note that application changes may be required due to new feature content provided in this release.

UseEnhancedSchemaTable Connection String Attribute

More detailed metadata is now retrieved from the Teradata Database. The additional metadata has primarily improved the functionality of some of the existing features of the provider. Refer to New Features for a list of behavior changes made to the provider.

The side affect is that the behavior of the provider has been slightly modified. To control whether the provider uses the new behavior, the UseEnhancedSchemaTable Connection String Attribute is used. The following is a list of changes:

The TdDataAdapter.SelectCommand must return a Key in order for TdCommandBuilder to generate UPDATE, INSERT and DELETE SQL commands when UseEnhancedSchemaTable is set to true and Teradata Database version is 6.2 or Higher. A Key will not be required if UseEnhancedSchemaTable is set to false or the Teradata Database version is 6.1 or earlier.
Additional columns are returned from the method TdDataReader.GetSchemaTable when UseEnhancedSchemaTable is set to true.

The default setting for the UseEnhancedSchemaTable Connection String Attribute is true. By default the provider will use the new behavior when connected to Teradata Database 6.2 or higher.

This attribute must be set to false if an application requires the behavior prior to the 13.0 release of the provider.

UseEnhancedSchemaTable Connection String Attribute

See Also