Class SqlOdbcConnectionManager

Sql Server Connection manager for an ODBC connection. ODBC by default does not support a Bulk Insert - inserting big amounts of data is translated into a

insert into (...) values (..),(..),(..) statements.

This means that inserting big amounts of data in a database via Odbc can be much slower than using the native connector. Also be careful with the batch size - some databases have limitations regarding the length of sql statements. Reduce the batch size if you encounter issues here.

Inheritance
object
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>
OdbcConnectionManager
SqlOdbcConnectionManager
Implements
Inherited Members
Namespace: ETLBox.Odbc
Assembly: ETLBox.Odbc.dll
Syntax
    public class SqlOdbcConnectionManager : OdbcConnectionManager, IConnectionManager<OdbcConnection, OdbcTransaction>, IConnectionManager, IDisposable

Constructors

SqlOdbcConnectionManager()

Declaration
    public SqlOdbcConnectionManager()

SqlOdbcConnectionManager(OdbcConnectionString)

Declaration
    public SqlOdbcConnectionManager(OdbcConnectionString connectionString)
Parameters
TypeNameDescription
OdbcConnectionStringconnectionString

SqlOdbcConnectionManager(string)

Declaration
    public SqlOdbcConnectionManager(string connectionString)
Parameters
TypeNameDescription
stringconnectionString

Methods

Clone()

Cretes a clone of the current connection manager

Declaration
    public override IConnectionManager Clone()
Returns
TypeDescription
IConnectionManager

A instance copy of the current connection manager

Overrides

Implements