EnableTdDecimal Property

Enables and disables mapping of Decimal(18) to TdDecimal provider specific type.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Property EnableTdDecimal As Boolean

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

public bool EnableTdDecimal {get; set;}

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

Property Value

Defaults to true. It can be set to false to disable creation of TdDecimal provider specific value type for Teradata Decimal data type with precision less than or equal to 18. It does not affect Teradata Decimal data type with precision greater than 18 (Large Decimal).

Remarks

TdDataReader.GetProviderSpecificFieldType will always return TdDecimal type when EnableTdDecimal is set to true. It will return Decimal when EnableTdDecimal is set to false and the data returned by the Advanced SQL Engine has a precision less than or equal to 18.

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

Default Value: true

Requirements

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

Reference

TdConnectionStringBuilder Class
TdConnectionStringBuilder Members