Class AdbOdbcDataSourceInformationService

Provides information about an ODBC SQL 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 ODBC 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
AdbOdbcDataSourceInformationService
Implements
Inherited Members
Namespace: actionETL.Adb.OdbcExternal
Assembly: actionETL.dll
Syntax
public class AdbOdbcDataSourceInformationService : AdbGenericDataSourceInformationService, IAdbDataSourceInformationService

Constructors

AdbOdbcDataSourceInformationService(IAdbConnection)

Initializes a new instance of the AdbOdbcDataSourceInformationService class, which provides information about an ODBC SQL 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 AdbOdbcDataSourceInformationService(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 AdbOdbcDataSourceInformationService (with default settings) on each invocation, which is used when instantiating a new AdbProvider for accessing an ODBC data source.

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

Implements

See Also