Class OracleOdbcConnectionManager
Oracle 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
Implements
Inherited Members
Namespace: ETLBox.Connection
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
Type | Name | Description |
---|---|---|
OdbcConnectionString | connectionString |
OracleOdbcConnectionManager(String)
Declaration
public OracleOdbcConnectionManager(string connectionString)
Parameters
Type | Name | Description |
---|---|---|
System.String | connectionString |
Properties
ConnectionManagerType
The database type for the connection manager.
Declaration
public override ConnectionManagerType ConnectionManagerType { get; protected set; }
Property Value
Type | Description |
---|---|
ConnectionManagerType |
Overrides
PP
The character that is used in front of parameter names in query to identify the parameter. All databases use the '@' character, except Oracle which uses ':'
Declaration
public override string PP { get; protected set; }
Property Value
Type | Description |
---|---|
System.String |
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
Type | Description |
---|---|
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
Type | Description |
---|---|
System.String |
Overrides
SupportDatabases
Indicates if database server does support multiple databases. A database in ETLBox means a schema in MySql.
Declaration
public override bool SupportDatabases { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
Overrides
SupportSchemas
Indicates if the database supports schemas In MySql, this is false because the schema here is a database in ETLBox. Use SupportDatabases instead
Declaration
public override bool SupportSchemas { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
Overrides
Methods
Clone()
Cretes a clone of the current connection manager
Declaration
public override IConnectionManager Clone()
Returns
Type | Description |
---|---|
IConnectionManager | A instance copy of the current connection manager |