Class PostgresOdbcConnectionManager

Postgres 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
object
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>
OdbcConnectionManager
PostgresOdbcConnectionManager
Implements
IConnectionManager<OdbcConnection, OdbcTransaction>
System.IDisposable
Inherited Members
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: ETLBox.Connection
Assembly: ETLBox.Odbc.dll
Syntax
    public class PostgresOdbcConnectionManager : OdbcConnectionManager, IConnectionManager<OdbcConnection, OdbcTransaction>, IConnectionManager, IDisposable

Constructors

PostgresOdbcConnectionManager()

Declaration
    public PostgresOdbcConnectionManager()

PostgresOdbcConnectionManager(OdbcConnectionString)

Declaration
    public PostgresOdbcConnectionManager(OdbcConnectionString connectionString)
Parameters
TypeNameDescription
OdbcConnectionStringconnectionString

PostgresOdbcConnectionManager(string)

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

System.IDisposable