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.

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

Reference

TdConnectionStringBuilder Class
TdConnectionStringBuilder Members