Class AdbSQLiteDataSourceInformationService

Provides information about a SQLite data source behind a connection, such as what character to use for quoting, how to specify parameter markers etc. The information is mainly taken from the "DataSourceInformation" schema collection, and is used to write provider-independent database code.

This class is used when creating AdbProvider instances, use one of the Get() overloads to retrieve the required delegate.

This class can be inherited to overwrite some values, and used to create a custom SQLite provider. See AdbProvider and Information.

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
AdbGenericDataSourceInformationService
AdbSQLiteDataSourceInformationService
Implements
Inherited Members
Namespace: actionETL.Adb.SQLiteExternal
Assembly: actionETL.dll
Syntax
public class AdbSQLiteDataSourceInformationService : AdbGenericDataSourceInformationService, IAdbDataSourceInformationService

Constructors

AdbSQLiteDataSourceInformationService(IAdbConnection)

Initializes a new instance of the AdbSQLiteDataSourceInformationService class, which provides information about a SQLite data source behind a connection, such as what character to use for quoting, how to specify parameter markers etc. This supports writing provider-independent database code.

Declaration
protected AdbSQLiteDataSourceInformationService(IAdbConnection adbConnection)
Parameters
Type Name Description
IAdbConnection adbConnection

An Adb database connection.
Exceptions
Type Condition
ArgumentNullException

adbConnection
InvalidOperationException
  • Cannot open a connection without specifying a data source or server.
  • May throw if the connection is associated with a transaction.

Methods

Get()

Gets a function that returns a new instance of AdbSQLiteDataSourceInformationService (with default settings) on each invocation, which is used when instantiating a new AdbProvider for accessing a SQLite data source.

Declaration
public static Func<IAdbConnection, IAdbDataSourceInformationService> Get()
Returns
Type Description
Func<IAdbConnection, IAdbDataSourceInformationService>

Implements

See Also