The .NET Data Provider for Teradata maps the Advanced SQL Engine data types to the .NET types. The Data Provider extends the Base Class Library (BCL) type system with Types (Value and Reference types) specific to the .NET Data Provider for Teradata and the SQL Engine.

This section will describe how the SQL data type maps to the .NET types and it provides best practices for retrieving data from the SQL Engine and sending Data to the SQL Engine.

In This Section

Data Type Mappings

Provider Specific Types

Accessor Methods for Retrieving Data

Configuring Parameters and Parameters Data Type

Handling Null Values

How Provider Types Handle Nulls

Array Data Type

Byte and BLOB Data Types

Character and CLOB Data Types

Date and Time Data Types

Geospatial Data Types

Interval Data Types

Large Object (LOB) Data Types

Numeric Data Types

Period Data Types

User Defined Type

TD_ANYTYPE Data Type

Xml Data Type