ProviderSpecificValue Property

Visual Basic
C#
C++/CLI

'Declaration
 
Public Property ProviderSpecificValue As Object

'Usage
 
Dim instance As TdParameter
Dim value As Object
 
instance.ProviderSpecificValue = value
 
value = instance.ProviderSpecificValue

public object ProviderSpecificValue {get; set;}

public:
property Object^ ProviderSpecificValue {
   Object^ get();
   void set (    Object^ value);
}

Property Value

Specifies an object reference. The default value is null.

Returns .NET Data Provider for Teradata specific data types like TdDecimal, TdBlob and TdClob. It returns Framework Class Library (FCL) types when there is no corresponding provider specific type. For example it returns Int32 for Teradata Integer data type.

.NET Data Provider for Teradata data types implement Data.SqlTypes.INullable interface. Data.SqlTypes.INullable.IsNull property must be used to check for null. FCL types do not support INullable, therefore null is represented by DBNull.Value.

Some of the provider specific types supported by the provider have a corresponding "Enable" Connection String Attribute. The setting of this attribute will affect the behavior of this property. Refer to the Enabling Provider Specific Types section of the Developers Guide for further information.

LOB output parameters maintain their own state, which includes the position within the LOB. The data reader is not able to reset the position to the start of a LOB so you must only call one of the following Properties or Methods, one time:

Value
ProviderSpecificValue
GetValue<T>

This example accesses a TdDecimal that has been returned in an Output parameter.

C#

// Setup the parameters 
command.Parameters.Add("RegionId", TdType.Integer);
command.Parameters["RegionId"].Direction = ParameterDirection.Input;
command.Parameters["RegionId"].Value = 120;
             
command.Parameters.Add("TotalSales", TdType.Decimal);
command.Parameters["TotalSales"].Direction = ParameterDirection.Output;
             
// Executes a stored procedure to retrieve Total Sales for Region 120
command.ExecuteNonQuery();
             
// Access the TdDecimal that was returned from the stored procedure
TdDecimal totalSales = (TdDecimal) command.Parameter["TotalSales"].ProviderSpecificValue;
                 
// Dispose command when done
command.Dispose();

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

Reference

TdParameter Class
TdParameter Members