AdoDatabaseProvider

AdoDatabaseProvider

public AdoDatabaseProvider(Func<DatabaseConnectionPair, DbConnection> connectionFactory)

adoDatabaseProvider = AdoDatabaseProvider(connectionFactory)

Pure ADO.NET implementation of IDatabaseProvider.

connectionFactory

Factory function that creates a DbConnection from connection pair.

AdoDatabaseProvider

public AdoDatabaseProvider()

adoDatabaseProvider = AdoDatabaseProvider()

Initializes a new instance using DatabaseProviderRegistry to create connections.

Instance

public static IDatabaseProvider Instance { get; private set; }

value = AdoDatabaseProvider.Instance
AdoDatabaseProvider.Instance = value

Default singleton instance backed by DatabaseProviderRegistry. Tests can swap this for a test double via IDatabaseProvider); production code should leave it alone.

CreateConnection

public IDatabaseConnection CreateConnection(DatabaseConnectionPair pair)

result = adoDatabaseProvider.CreateConnection(pair)

Creates a database connection from the specified connection settings.

pair

Database connection settings.

Returns: A database connection instance.

GetTable

public IDatabaseTable GetTable(IDatabaseConnection connection, string tableName)

result = adoDatabaseProvider.GetTable(connection, tableName)

Gets a table accessor for the specified table.

connection

Database connection.

tableName

Table name.

Returns: Table accessor with DDL and DML operations.

OverrideInstance

public static void OverrideInstance(IDatabaseProvider provider)

AdoDatabaseProvider.OverrideInstance(provider)

Override the global Instance. Intended for tests; pass to restore the default AdoDatabaseProvider.