GetProviderSpecificValue Method

Visual Basic
C#
C++/CLI

'Declaration
 
Public Overrides NotOverridable Function GetProviderSpecificValue( _
   ByVal ordinal As Integer _
) As Object

'Usage
 
Dim instance As TdDataReader
Dim ordinal As Integer
Dim value As Object
 
value = instance.GetProviderSpecificValue(ordinal)

public override object GetProviderSpecificValue( 
   int ordinal
)

public:
Object^ GetProviderSpecificValue( 
   int ordinal
) override

Parameters

ordinal: Column ordinal (see TdDataReader.GetOrdinal).

Return Value

Returns the value of the specified field represented as a System.Object type.

Exception	Description
System.IndexOutOfRangeException	ordinal is less than zero or ordinal is equal to or greater than TdDataReader.FieldCount or operating in Data.CommandBehavior.SequentialAccess mode and specified column is not accessible.
System.InvalidOperationException	CommandBehavior is set to SchemaOnly, or there is no data for the row or column, or preceding columns are no longer accessible.
System.ObjectDisposedException	The TdDataReader is closed.
TdException	The Advanced SQL Engine returned an error or .NET Data Provider for Teradata detected an error.

GetProviderSpecificValue returns a System.Object (It is the root of all types) and therefore is used to retrieve any Teradata data type. The Data Provider maps the Teradata data types to .NET Framework types and returns a reference to the .NET Framework instance. It returns TdBlob and TdClob instances when BLOB and CLOB columns are retrieved in deferred mode.

GetProviderSpecificValue is the most flexible field retrieval method and is also the slowest field retrieval method. It is strongly recommended to use the other strongly typed field retrieval methods (for example, GetInt32).

This method does not throw an exception for null database fields. It returns an instance of DBNull.

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

Reference

TdDataReader Class
TdDataReader Members