Class AdbSQLiteTypeService

Gets and sets types and values on database parameters for a System.Data.SQLite provider, such as AdbSQLiteProvider.

Note that SQLite has no provider-specific types, so this class will use SQLiteParameter.DbType and SQLiteParameter.Value.

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
AdbSQLiteTypeService
Implements
Namespace: actionETL.Adb.SQLiteExternal
Assembly: actionETL.dll
Syntax
public sealed class AdbSQLiteTypeService : IAdbTypeService

Methods

Get()

Gets a singleton instance of AdbSQLiteTypeService, which is used when instantiating a new AdbProvider for accessing an ODBC data source.

Declaration
public static IAdbTypeService Get()
Returns
Type Description
IAdbTypeService

GetProviderType(DbParameter)

Gets the SQLiteParameter.DbType enumeration value, since SQLite parameters has no provider-specific types.

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

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

SQLiteParameter.DbType enumeration value, as an object.
Exceptions
Type Condition
ArgumentException

Parameter is not a SQLiteParameter.
ArgumentNullException

dbParameter

GetProviderValue(DbParameter)

Gets the DbParameter.Value, since SQLite parameters has no provider-specific value.

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

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

SQLiteParameter.Value, as an object.
Exceptions
Type Condition
ArgumentException

dbParameter is not a SQLiteParameter.
ArgumentNullException

dbParameter

SetProviderType(DbParameter, Object)

Gets the SQLiteParameter.DbType enumeration value, since SQLite parameters has no provider-specific types.

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

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

DbParameter.DbType enumeration value, as an object.
Exceptions
Type Condition
ArgumentException
  • dbParameter is not a SQLiteParameter.
  • providerTypeEnum is not a DbType.
ArgumentNullException
  • dbParameter
  • providerTypeEnum

SetProviderValue(DbParameter, Object)

Sets SQLiteParameter.Value, since SQLite parameters has no provider-specific value.

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

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

SQLiteParameter.Value value, as an object.
Exceptions
Type Condition
ArgumentException

dbParameter is not a SQLiteParameter.
ArgumentNullException

dbParameter

Implements

See Also