The Connection-String attribute Enable TdDateTime has been added to prevent possible compatibility issues for application built against the .NET Data Provider for Teradata version 1.2 or earlier. This attribute will allow applications to enable/disable the mapping of the SQL Date And Time data types to the Provider Specific Date And Time data types.
Compatibility issue will occur when an older application has set the TdDataAdapter.ReturnProviderSpecificTypes to true and expects the corresponding BCL types to be used in the columns of the resulting DataTable. If BCL types are expected, Enable TdDateTime must be set to false. The connection string that is specified to force this behavior is similar to the following:
Data Source = Teradata1; User ID = Tuser; Password = Tpass; Enable TdDateTime = false;Refer to Enabling Provider Specific Types for further information.