OracleOdbcConnectionManager

Class OracleOdbcConnectionManager

Oracle 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.

Inherited Members
Namespace: ETLBox.Odbc
Assembly: ETLBox.Odbc.dll
Syntax
    public class OracleOdbcConnectionManager : OdbcConnectionManager, IConnectionManager<OdbcConnection, OdbcTransaction>, IConnectionManager, IDisposable

Constructors

OracleOdbcConnectionManager()

Declaration
    public OracleOdbcConnectionManager()

OracleOdbcConnectionManager(OdbcConnectionString)

Declaration
    public OracleOdbcConnectionManager(OdbcConnectionString connectionString)
Parameters
TypeNameDescription
OdbcConnectionStringconnectionString

OracleOdbcConnectionManager(string)

Declaration
    public OracleOdbcConnectionManager(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