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
System.Object
DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>
PostgresOdbcConnectionManager
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 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
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