Send feedback on this topic.
Teradata.Client.Provider
Teradata.Client.Provider Namespace
Inheritance Hierarchy
The .NET Data Provider for Teradata is an implementation of the Microsoft ADO.NET Data Provider specification. It provides direct access to the Teradata Database and integrates with the DataSet (System.Data.DataSet class). .NET Applications use the .NET Data Provider for Teradata to load data into the Teradata Database or retrieve data from the Teradata Database.
Classes
 ClassDescription
Class TdBlob represents a BLOB (Binary Large Object) data type instance. It is used to retrieve a BLOB from the Advanced SQL Engine.
Class TdClob represents a CLOB (Character Large Object) data type instance. It is used to retrieve CLOB data from the Advanced SQL Engine.
Class TdCommand class represents a SQL request. The request can be either a Single SQL statement or Multi-Statement SQL.
Class The TdCommandBuilder generates DML statements (UPDATE, INSERT and DELETE) which are used by TdDataAdapter. The TdDataAdapter applies changes to a DataSet (or DataTable) back to the Teradata Vantage Advanced SQL Engine.
ClassTdConnection class represents a connection or session to Teradata. It is used to specify the session characteristics such as Session Character Set or User Id when including a TdConnection.ConnectionString in the constructor.
Class Facilitates creation of a connection string for the .NET Data Provider for Teradata.
Class TdDataAdpater fills a DataSet with the data from the Teradata Vantage Advanced SQL Engine and conversely updates the SQL Engine with the data in a DataSet.
Class Represents a static forward-only cursor where the individual fields within the current row are accessible using the supported accessor methods.
Class Represents a warning or error returned by the Advanced SQL Engine, the .Net Data Provider for Teradata or TeraGSS.
ClassHolds zero or more instances of the TdError class.
Class TdException is a custom exception class reporting errors detected by the .NET Data Provider for Teradata or the Advanced SQL Engine.
Class Creates instances of TdCommand, TdCommandBuilder, TdConnection, TdDataAdapter and TdParameter classes.
Class This class contains information about the file that was specified in the DDL statement to create a function (e.g. stored procedure, UDF, UDT). The information that it contains are: name of file, type of file, source language of function.
Class Arguments for the TdInfoMessage event
Class Represents a parameter to a SQL statement.
ClassRepresents a collection of TdParameter objects associated with a TdCommand object.
ClassTdQueryBand manages Teradata Query Bands for an application. It enables an application to create, modify, and remove Query Bands. Query Bands that are managed by TdQueryBand can be applied to a Connection or Transaction by calling TdConnection.ChangeQueryBand or TdTransaction.ChangeQueryBand, respectively.
ClassClass to change the TdConnectionStringBuilder.RecoveryTimeout, when the TdConnection.RecoverConnection event is activated during reconnection.
Class Arguments to the TdRowUpdatingEventHandler delegate. It provides data for the TdDataAdapter.RowUpdating event.
Class Arguments to the TdRowUpdatingEventHandler delegate. It provides data for the TdDataAdapter.RowUpdating event.
Class TdStream is used to retrieve a BLOB from the Teradata Vantage Advanced SQL Engine.
Class Represents an Explicit SQL Transaction. It should be explicitly committed or rolled back.
Class TdXml represents a Xml data type. It is used to retrieve Xml data from a Teradata Vantage Advanced SQL Engine.
Structures
 StructureDescription
Structure TdDate is a .Net Data Provider for Teradata specific type that represents a date which is based on the Gregorian Calendar.
Structure Teradata can support decimals that have a precision/scale up to 38. The .NET Framework can only support a decimal that has a scale of up to 28. TdDecimal enables an application to receive and send Large Decimals from and to Teradata. It also contains arithmetic, comparison, and conversion methods that can be used to operate on Large Decimals. A numeric value between - 10^38 +1 and 10^38 - 1 is supported.
StructureTdIntervalDay represents an interval of time defining a duration in days. The day precision is configurable.
StructureTdIntervalDayToHour represents an interval of time defining a duration in days and hours. The day precision is configurable.
StructureTdIntervalDayToMinute represents an interval of time defining a duration in days, hours and minutes. The day precision is configurable.
StructureTdIntervalDayToSecond represents an interval of time defining a duration in days, hours, minutes, seconds and microseconds. The day precision and the second scale are configurable.
StructureTdIntervalHour represents an interval of time defining a duration in hours. The hour precision is configurable.
StructureTdIntervalHourToMinute represents an interval of time defining a duration in hours and minutes. The hour precision is configurable.
StructureTdIntervalHourToSecond represents an interval of time defining a duration in hours, minutes, seconds and fractional seconds. The hour precision and second scale are configurable.
StructureTdIntervalMinute represents an interval of time defining a duration in minutes. The minute precision is configurable.
StructureTdIntervalMinuteToSecond represents an interval of time defining a duration in minutes, seconds and fractional seconds. The minute precision and second scale are configurable.
StructureTdIntervalMonth represents an interval of time defining a duration in months. The month precision is configurable from 1 - 4 significant digits.
StructureTdIntervalSecond represents an interval of time defining a duration in seconds and fractional seconds. The second precision and scale are configurable.
StructureTdIntervalYear represents an interval of time defining a duration in years. The year precision is configurable from 1 - 4 significant digits.
StructureTdIntervalYearToMonth represents an interval of time defining a duration in years and/or months. The year precision is configurable from 1 - 4 significant digits.
Structure

The Teradata Database 14.0 and later supports a data type called NUMBER. This data type supports fixed point decimal (Fixed Decimal) and floating point (Floating Decimal) numbers. Fixed decimals can support up to 38 significant digits. Floating decimals can support up 40 digits, however, the precision of the number is guaranteed only up to 38 digits.

TdNumber is the equivalent Provider Specific Type to NUMBER. The range of TdNumber is +/-[1E-130 to 9.99...9E125] as well as 0. It will also support a precision of up to 40 digits.

TdNumber can also be used to receive and send numbers from and to the Advanced SQL Engine.

Structure TdPeriodDate is a .Net Data Provider for Teradata specific type that represents a duration of time that is bound by beginning and ending dates. The dates are based on the Gregorian calendar.
Structure TdPeriodTime is a .Net Data Provider for Teradata specific type that represents a duration of time that is bound by beginning and ending times.
Structure TdPeriodTimestamp is a .Net Data Provider for Teradata specific type that represents a duration of time that is bound by beginning and ending timestamps.
Structure TdPeriodTimestampWithTimeZone is a .Net Data Provider for Teradata specific type that represents a duration of time that is bound by beginning and ending timestamps that have a time zone.
Structure TdPeriodTimeWithTimeZone is a .Net Data Provider for Teradata specific type that represents a duration of time that is bound by beginning and ending times that have a time zone.
Structure TdTime is a .Net Data Provider for Teradata specific type that represents the time of day.
Structure TdTimestamp is a .Net Data Provider for Teradata specific type that represents a timestamp that is based on the Gregorian Calendar.
Structure TdTimeStampWithTimeZone is a .Net Data Provider for Teradata specific type that represents a timestamp with a Time Zone and based on the Gregorian Calendar.
Structure TdTimeWithTimeZone is a .Net Data Provider for Teradata specific type that represents the time of day, and allows a Time Zone to be specified.
Delegates
 DelegateDescription
Delegate Represents the method that will handle the CloseFile event.
Delegate Represents the method that will handle the TdInfoMessage event.
Delegate Represents the method that will handle the OpenFile event.
Delegate Delegate that will handle the TdDataAdapter.RowUpdated event.
Delegate Delegate that will handle the TdDataAdapter.RowUpdating event.
Enumerations
 EnumerationDescription
Enumeration The File Types that are supported by the Advanced SQL Engine when compiling a function.
Enumeration Generated data retrieval behavior.
Enumeration The Source Languages that are supported by the Advanced SQL Engine to write a function.
Enumeration TdType is an enumeration of the Teradata Vantage SQL data types.
See Also

Reference

Teradata.Client.Provider Assembly