Class SqlOdbcConnectionManager

Sql Server Connection manager for an ODBC connection based on ADO.NET to Sql Server. 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
System.Object
DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>
SqlOdbcConnectionManager
Implements
IConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction>
System.IDisposable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.Connection
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
System.StringconnectionString

Properties

ConnectionManagerType

The database type for the connection manager.

Declaration
    public override ConnectionManagerType ConnectionManagerType { get; protected set; }
Property Value
TypeDescription
ConnectionManagerType
Overrides

QB

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

Declaration
    public override string QB { get; protected set; }
Property Value
TypeDescription
System.String
Overrides

QE

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

Declaration
    public override string QE { get; protected set; }
Property Value
TypeDescription
System.String
Overrides

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

System.IDisposable