Class AdbSQLiteTypeMapper

Stores mappings between .NET types and database types, and allows setting the database type of database parameters from these mappings.

This class adds mappings for SQLite database types. See the Data Type Mappings , as well as AdbTypeMapper and predefined type mappings for further details.

This class can be derived from to create a customized provider that revises and adds mappings.

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
AdbTypeMapper
AdbSQLiteTypeMapper
Implements
Inherited Members
Namespace: actionETL.Adb.SQLiteExternal
Assembly: actionETL.dll
Syntax
public class AdbSQLiteTypeMapper : AdbTypeMapper, IAdbTypeMapper

Constructors

AdbSQLiteTypeMapper()

Initializes a new instance of the AdbSQLiteTypeMapper class, which stores SQLite mappings between .NET types and database types, and allows setting the database type of database parameters from these mappings.

Declaration
public AdbSQLiteTypeMapper()

Methods

Get()

Gets a singleton instance of AdbSQLiteTypeMapper, which is used when instantiating a new AdbProvider for accessing a SQLite data source.

Declaration
public static IAdbTypeMapper Get()
Returns
Type Description
IAdbTypeMapper

SetMappedType(AdbParameter, Type, AdbColumnSchema, ParameterDirection)

Set the database type of a database parameter, using previously defined mappings.

The database type can be provider-independent such as System.Data.DbType Int32, or a provider-specific one such as System.Data.SqlDbType UniqueIdentifier, or Untyped, which means the provider deduces the database type for each value, e.g. for each row.

If no pre-defined mapping is found, and dotNetType is an enum or nullable enum, and adbColumnSchema is either null or an integral type, then the parameter is mapped to the enum underlying type. This allows the enum to be stored in an integer column.

Declaration
public override bool SetMappedType(AdbParameter adbParameter, Type dotNetType, AdbColumnSchema adbColumnSchema, ParameterDirection direction)
Parameters
Type Name Description
AdbParameter adbParameter

The database parameter. Must not be null.
Type dotNetType

The .NET CLR type (string, SqlDateTime, etc.) Must not be null.
AdbColumnSchema adbColumnSchema

The schema for the database column, or null if not available.
ParameterDirection direction

The parameter direction.
Returns
Type Description
Boolean

true if a mapping was found (including Untyped), otherwise false.
Overrides
Exceptions
Type Condition
ArgumentException
  • providerTypeEnum is not of the correct provider type.
  • The property is not set to a valid DbType.
ArgumentNullException
  • adbColumnSchema
  • adbParameter
  • dotNetType

Implements

See Also