EnableTdIntervals Property

Visual Basic
C#
C++/CLI

'Declaration
 
Public Property EnableTdIntervals As Boolean

'Usage
 
Dim instance As TdConnectionStringBuilder
Dim value As Boolean
 
instance.EnableTdIntervals = value
 
value = instance.EnableTdIntervals

public bool EnableTdIntervals {get; set;}

public:
property bool EnableTdIntervals {
   bool get();
   void set (    bool value);
}

Property Value

Defaults to true. It can be set to false to disable creation of provider specific interval value types for the corresponding Teradata Interval data types.

The Day-Time intervals supported by the provider are:

and the Year-Month intervals supported by the provider are:

The setting of EnableTdIntervals affects the behavior of the following methods:

Method	Behavior
TdDataReader.GetProviderSpecificFieldType	Setting is `true` Returns the Provider Specific Interval data type corresponding to the SQL Interval data type. Setting is `false` All intervals will return the .NET Framework Class Library data type of String.
TdDataReader.GetFieldType	Setting is `true` All Day-Time intervals will return the .NET Framework Class Library data type of TimeSpan. All Year-Month intervals will return the .NET Framework Class Library data type of String. Setting is `false` All intervals will return the .NET Framework Class Library data type of String.
TdDataReader.GetValue	Setting is `true` All Day-Time intervals will return the .NET Framework Class Library data type of TimeSpan. All Year-Month intervals will return the .NET Framework Class Library data type of String. Setting is `false` All intervals will return the .NET Framework Class Library data type of String.
TdDataReader.GetProviderSpecificValue	Setting is `true` Returns the Provider Specific Interval data value corresponding to the SQL Interval data type. Setting is `false` All intervals will return the .NET Framework Class Library data value of a String.
TdParameter.Value Property	Setting is `true` All Day-Time intervals will return the .NET Framework Class Library data value of a TimeSpan. All Year-Month intervals will return the .NET Framework Class Library data value of a String. Setting is `false` All intervals will return the .NET Framework Class Library data value of a String.
TdParameter.ProviderSpecificValue Property	Setting is `true` Returns the Provider Specific Interval data value corresponding to the SQL Interval data type. Setting is `false` All intervals will return the .NET Framework Class Library data value of a String.

This feature has been added for backward compatibility with older applications. For example an older application, might have set Data.Common.DataAdapter.ReturnProviderSpecificTypes to true and later assumed that the resulting columns in Data.DataTable are of System.String type.

Product	Versions	Platforms
.NET	2.1, 3.1, 6	Windows, Linux, MacOS
.NET Framework	4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8	Windows
.NET Standard	2.0	Windows, Linux, MacOS

Reference

TdConnectionStringBuilder Class
TdConnectionStringBuilder Members