Send feedback on this topic.
Teradata.Client.Provider
Version 13.1.0
.NET Data Provider for Teradata > Developer's Guide > Migration Considerations for the .NET Data Provider for Teradata > Version 13.1.0

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

EnableDateTimeOffset Connection String Attribute

Microsoft introduced System.DateTimeoffset in .NET Framework 2.0 SP1. It corresponds to Teradata TIMESTAMP WITH TIME ZONE data type. The provider now supports DateTimeOffset. However, to maintain backward compatibility, the Connection String Attribute EnableDatetimeOffset was introduced.

To control whether the provider maps TIMESTAMP WITH TIME ZONE to System.DateTimeOffset, the EnableDateTimeOffset Connection String Attribute is used.

The default setting for the EnableDateTimeOffset Connection String Attribute is true. By default the provider will use the new behavior to map TIMESTAMP WITH TIME ZONE data type.

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

EnableTdIntervals Connection String Attribute

A new Connection String Attribute TdConnectionStringBuilder.EnableTdIntervals was added to enable or disable mapping of all Teradata Database interval data types to provider specific data types - TdIntervalDayToSecond, TdIntervalDayToMinute, TdIntervalDayToHour, TdIntervalDay, TdIntervalHourToSecond, TdIntervalHourToMinute, TdIntervalHour, TdIntervalMinuteToSecond, TdIntervalMinute, TdIntervalSecond, TdIntervalYear, TdIntervalMonth and TdIntervalYearToMonth.

By disabling the Connection String Attribute EnableTdIntervals the Teradata Database interval data types retain backward compatibility with release 13.0 and prior versions of the provider. By enabling the Connection String Attribute EnableTdIntervals the new provider specific types are available with their corresponding new behavior. Refer to Whats New in 13.01.00.00 for a list of behavior changes made to the provider.

The default setting for the EnableTdIntervals Connection String Attribute is true. By default the provider will map all the Teradata Interval data types to provider specific data types.

See Also

What's New in the .Net Data Provider for Teradata 13.1.0.0

TdConnectionStringBuilder.EnableDateTimeOffset

TdConnectionStringBuilder.EnableTdIntervals