Class AdbSqlClientTypeService

Gets and sets types and values on database parameters for a Microsoft.Data.SqlClient provider for a SQL Server® data source, such as AdbSqlClientProvider.

This class is immutable. This avoids threading issues, since an instance is often accessed by multiple threads. Any user custom provider services should also be immutable for the same reason.

Inheritance
Object
AdbSqlClientTypeService
Implements
Namespace: actionETL.Adb.SqlClientExternal
Assembly: actionETL.dll
Syntax
public sealed class AdbSqlClientTypeService : IAdbTypeService

Methods

Get()

Gets a singleton instance of AdbSqlClientTypeService, which is used when instantiating a new AdbProvider for accessing a SQL Server® provider.

Declaration
public static IAdbTypeService Get()
Returns
Type Description
IAdbTypeService

GetProviderType(DbParameter)

Gets the provider-specific SqlParameter.SqlDbType enumeration value.

Declaration
public object GetProviderType(DbParameter dbParameter)
Parameters
Type Name Description
DbParameter dbParameter

The database parameter, which must be of type SqlParameter.
Returns
Type Description
Object

SqlParameter.SqlDbType enumeration value, as an object.
Exceptions
Type Condition
ArgumentException

Parameter is not a SqlParameter.
ArgumentNullException

dbParameter

GetProviderValue(DbParameter)

Gets the provider-specific SqlParameter.SqlValue value.

Declaration
public object GetProviderValue(DbParameter dbParameter)
Parameters
Type Name Description
DbParameter dbParameter

The database parameter, which must be of type SqlParameter.
Returns
Type Description
Object

SqlParameter.SqlValue value, as an object.
Exceptions
Type Condition
ArgumentException

dbParameter is not a SqlParameter.
ArgumentNullException

dbParameter

SetProviderType(DbParameter, Object)

Sets the provider-specific SqlParameter.SqlDbType enumeration value.

Declaration
public void SetProviderType(DbParameter dbParameter, object providerTypeEnum)
Parameters
Type Name Description
DbParameter dbParameter

The database parameter, which must be of type SqlParameter.
Object providerTypeEnum

SqlParameter.SqlDbType enumeration value, as an object.
Exceptions
Type Condition
ArgumentException
ArgumentNullException
  • dbParameter
  • providerTypeEnum

SetProviderValue(DbParameter, Object)

Sets the provider-specific SqlParameter.SqlValue value.

Declaration
public void SetProviderValue(DbParameter dbParameter, object value)
Parameters
Type Name Description
DbParameter dbParameter

The database parameter, which must be of type SqlParameter.
Object value

SqlParameter.SqlValue value, as an object.
Exceptions
Type Condition
ArgumentException

dbParameter is not a SqlParameter.
ArgumentNullException

dbParameter

Implements

See Also