Teradata.Client.Provider Namespace

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
	LogSettings	Class to read the log settings configuration file
	TdBlob	TdBlob represents a BLOB (Binary Large Object) data type instance. It is used to retrieve a BLOB from the Teradata database.
	TdClob	TdClob represents a CLOB (Character Large Object) data type instance. It is used to retrieve CLOB data from the Teradata Database.
	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 Database.
	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 Database and conversely updates the Teradata Database 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 Teradata Database, 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 Teradata Database.
	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 Teradata Database.
	TdTransaction	Represents an Explicit Teradata Database 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 Database.

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 Teradata Database.
	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

	Delegate	Description
	TdCloseFileEventHandler	Represents the method that will handle the CloseFile event.
	TdInfoMessageEventHandler	Represents the method that will handle the TdInfoMessage event.
	TdOpenFileEventHandler	Represents the method that will handle the OpenFile event.
	TdRowUpdatedEventHandler	Delegate that will handle the TdDataAdapter.RowUpdated event.
	TdRowUpdatingEventHandler	Delegate that will handle the TdDataAdapter.RowUpdating event.

Enumerations

	Enumeration	Description
	FileType	The File Types that are supported by the Teradata Database when compiling a function.
	GeneratedDataBehavior	Generated data retrieval behavior.
	SourceLanguage	The Source Languages that are supported by the Teradata Database to write a function.
	TdType	TdType is an enumeration of Teradata data types.

Reference

Teradata.Client.Provider Assembly