Class DbConnectionManager<TConnection, TTransaction, TParameter>

The generic implementation on which all connection managers are based on

The timeout used when executing sql commands with this connection manager. Default is 0 (no timeout)

Information about compatibility of the current connector

The connection string used to establish the connection with the database

The database type for the connection manager.

The underlying ADO.NET connection. Only read from this object and it's properties - by default, connections are always acquired from the connection pool.

Indicates if the current connection has a transaction assigned

Indicates if the current connection is currently used in a bulk insert operation (e.g. performed by a DbDestination)

Indicates if the current connection manager is used as a OleDb or Odbc Connection.

By default, after every sql operation the underlying ADO.NET connection is closed and retured to the ADO.NET connection pool. (This is the recommended behavior) To keep the connection open and avoid having the connection returned to the pool, set this to true. A connnection will be left open when a bulk insert operation is executed or a transaction hase been openend and not yet commited or rolled back.

Number of attempts that the connection managers tries to connect before it decides that the database is not reachable.

Returns the maximum amount of parameters that can be used for bulk inserts.

Returns the maximum amount of parameters that can be passed into a sql query.

The character that is used in front of parameter names in query to identify the parameter. Most databases use the '@' character, some use ':'.

The quotation begin character that is used in the database. E.g. SqlServer uses: '[' and Postgres: '"'

The quotation end character that is used in the database. E.g. SqlServer uses: ']' and Postgres: '"'

The state of the underlying ADO.NET connection

Indicates if database server does support multiple databases. A database in ETLBox means a schema in MySql.

Indicates if database server does support indexes.

Indicates if the database supports procedures

Indicates if the database supports schemas In MySql, this is false because the schema here is a database in ETLBox. Use SupportDatabases instead

The current transaction. Use BeginTransaction() to start a transaction, and CommitTransaction() or RollbackTransaction() to commit or rollback.

Indicates if a value to sql conversion function was set via SetValueToSqlConversionFunc(Func<ConversionContext, string>)

Will start a transaction with the default isolation level. This will leave the underlying ADO.NET connection open until the transaction is committed or rolled back.

Will start a transaction with the given isolation level (if supported by the target database) This will leave the underlying ADO.NET connection open until the transaction is committed or rolled back.

Performs a bulk delete

Performs a bulk insert

Performs a bulk select

Performs a bulk update

Called after the whole bulk insert operation to change back settings made to improve bulk insert performance

Cretes a clone of the current connection manager

Try to create a clone of the current connection - only possible if LeaveOpen is false.

Closes the connection - this will not automatically disconnect from the database server, it will only return the connection to the ADO.NET connection pool for further reuse.

Closes the connection only if leave open is set to false and no transaction or bulk insert is in progress.

Commits the current tranasction.

Copies the connection manager base attribnutes from the current connection manager to the target connection manager.

By default, a db connection is created with the given connection string value. Override this method if you want to pass additional properties to the specific Ado.NET db connection.

Closes the connection - this will not automatically disconnect from the database server, it will only return the connection to the ADO.NET connection pool for further reuse.

Executes a query against the database that doesn't return any data.

Executes a query asynchronously against the database that doesn't return any data.

Executes a query against the database that does return multiple rows in multiple columns. Define a read action for each columns of your result set.

Executes a query asynchronously against the database that does return multiple rows in multiple columns. Define a read action for each columns of your result set.

Executes a query against the database that returns a single row in a single column.

Executes a query asynchronously against the database that returns a single row in a single column.

Opens the connection to the database. Normally you don't have to do this on your own, as all tasks and components will try to open a connection if no open connection is found.

Opens the connection to the database asynchrously. Normally you don't have to do this on your own, as all tasks and components will try to open a connection if no open connection is found.

Changes the connection manager type for the generic connector, so that you can try to use it with not supported setups. If you are looking for supported Odbc connection managers, try to use the specific connection managers (e.g. MySqlOdbcConnectionManager for MySql or PostgresOdbcConnectionManager for Postgres)

Performs preparations needed to improved performance of a bulk insert operation

Rolls the current transaction back.

If sql is used to insert/update/delete data into the destination tables, the values are injected into the sql via parameters. If a value to sql conversion func is set, the parameters are bypassed and the sql can be influenced directly with this function.