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
| Class | Description |
| TdBlob |
TdBlob represents a BLOB (Binary Large Object) data type instance.
It is used to retrieve a BLOB from the Advanced SQL Engine.
|
| TdClob |
TdClob represents a CLOB (Character Large Object) data type instance.
It is used to retrieve CLOB data from the Advanced SQL Engine.
|
| TdCommand |
TdCommand class represents a SQL request. The request can be either
a Single SQL statement or Multi-Statement SQL.
|
| TdCommandBuilder |
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.
|
| TdConnection | TdConnection 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. |
| TdConnectionStringBuilder |
Facilitates creation of a connection string for the .NET Data Provider for Teradata.
|
| TdDataAdapter |
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.
|
| TdDataReader |
Represents a static forward-only cursor where the individual fields within
the current row are accessible using the supported accessor methods.
|
| TdError |
Represents a warning or error returned by the Advanced SQL Engine, the
.Net Data Provider for Teradata or TeraGSS.
|
| TdErrorCollection | Holds zero or more instances of the TdError class. |
| TdException |
TdException is a custom exception class reporting errors detected by
the .NET Data Provider for Teradata or the Advanced SQL Engine.
|
| TdFactory |
Creates instances of TdCommand, TdCommandBuilder, TdConnection, TdDataAdapter and
TdParameter classes.
|
| TdFileEventArgs |
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.
|
| TdInfoMessageEventArgs |
Arguments for the TdInfoMessage event
|
| TdParameter |
Represents a parameter to a SQL statement.
|
| TdParameterCollection | Represents a collection of TdParameter objects associated with a TdCommand object. |
| TdQueryBand | TdQueryBand 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. |
| TdRecoveryEventArgs | Class to change the TdConnectionStringBuilder.RecoveryTimeout, when the TdConnection.RecoverConnection event is activated during reconnection. |
| TdRowUpdatedEventArgs |
Arguments to the TdRowUpdatingEventHandler delegate. It provides data for
the TdDataAdapter.RowUpdating event.
|
| TdRowUpdatingEventArgs |
Arguments to the TdRowUpdatingEventHandler delegate. It provides data for
the TdDataAdapter.RowUpdating event.
|
| TdStream |
TdStream is used to retrieve a BLOB from the Teradata Vantage Advanced SQL Engine.
|
| TdTransaction |
Represents an Explicit SQL Transaction. It should be
explicitly committed or rolled back.
|
| TdXml |
TdXml represents a Xml data type. It is used to retrieve Xml data from
a Teradata Vantage Advanced SQL Engine.
|
Structures
| Structure | Description |
| TdDate |
TdDate is a .Net Data Provider for Teradata specific type that represents a date
which is based on the Gregorian Calendar.
|
| TdDecimal |
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.
|
| TdIntervalDay | TdIntervalDay represents an interval of time defining a duration in days. The day precision is configurable. |
| TdIntervalDayToHour | TdIntervalDayToHour represents an interval of time defining a duration in days and hours. The day precision is configurable. |
| TdIntervalDayToMinute | TdIntervalDayToMinute represents an interval of time defining a duration in days, hours and minutes. The day precision is configurable. |
| TdIntervalDayToSecond | TdIntervalDayToSecond represents an interval of time defining a duration in days, hours, minutes, seconds and microseconds. The day precision and the second scale are configurable. |
| TdIntervalHour | TdIntervalHour represents an interval of time defining a duration in hours. The hour precision is configurable. |
| TdIntervalHourToMinute | TdIntervalHourToMinute represents an interval of time defining a duration in hours and minutes. The hour precision is configurable. |
| TdIntervalHourToSecond | TdIntervalHourToSecond represents an interval of time defining a duration in hours, minutes, seconds and fractional seconds. The hour precision and second scale are configurable. |
| TdIntervalMinute | TdIntervalMinute represents an interval of time defining a duration in minutes. The minute precision is configurable. |
| TdIntervalMinuteToSecond | TdIntervalMinuteToSecond represents an interval of time defining a duration in minutes, seconds and fractional seconds. The minute precision and second scale are configurable. |
| TdIntervalMonth | TdIntervalMonth represents an interval of time defining a duration in months. The month precision is configurable from 1 - 4 significant digits. |
| TdIntervalSecond | TdIntervalSecond represents an interval of time defining a duration in seconds and fractional seconds. The second precision and scale are configurable. |
| TdIntervalYear | TdIntervalYear represents an interval of time defining a duration in years. The year precision is configurable from 1 - 4 significant digits. |
| TdIntervalYearToMonth | TdIntervalYearToMonth represents an interval of time defining a duration in years and/or months. The year precision is configurable from 1 - 4 significant digits. |
| TdNumber | 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. |
| TdPeriodDate |
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.
|
| TdPeriodTime |
TdPeriodTime is a .Net Data Provider for Teradata specific type that represents
a duration of time that is bound by beginning and ending times.
|
| TdPeriodTimestamp |
TdPeriodTimestamp is a .Net Data Provider for Teradata specific type that represents
a duration of time that is bound by beginning and ending timestamps.
|
| TdPeriodTimestampWithTimeZone |
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.
|
| TdPeriodTimeWithTimeZone |
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.
|
| TdTime |
TdTime is a .Net Data Provider for Teradata specific type that represents the
time of day.
|
| TdTimestamp |
TdTimestamp is a .Net Data Provider for Teradata specific type that
represents a timestamp that is based on the Gregorian Calendar.
|
| TdTimestampWithTimeZone |
TdTimeStampWithTimeZone is a .Net Data Provider for Teradata specific type that
represents a timestamp with a Time Zone and based on the Gregorian Calendar.
|
| TdTimeWithTimeZone |
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
Enumerations
| Enumeration | Description |
| FileType |
The File Types that are supported by the Advanced SQL Engine when
compiling a function.
|
| GeneratedDataBehavior |
Generated data retrieval behavior.
|
| SourceLanguage |
The Source Languages that are supported by the Advanced SQL Engine to write
a function.
|
| TdType |
TdType is an enumeration of the Teradata Vantage SQL data types.
|
See Also