Class OdbcConnectionManager
Generic OdbcConnectionManager - try this connection manager if no particular connection manager for your database exists. There are some limitations to the ETLBox functionality when you use this connection manager:
- Most ControlFlow Tasks won't work properly, depending on your database
- SqlTask will work
- If you use special characters, you need to set the quotation begin / quotation end properties QB and QE that fit to your database (e.g. "[" and "]" for Sql Server or "`" for MySql)
- DbDestination and DbSource will only work if you provide a TableDefinition that at least define the table and the columns names
Inheritance
object
OdbcConnectionManager
Inherited Members
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BeginTransaction(IsolationLevel)
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 OdbcConnectionManager : DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>, IConnectionManager<OdbcConnection, OdbcTransaction>, IConnectionManager, IDisposable
Constructors
OdbcConnectionManager()
Declaration
public OdbcConnectionManager()
OdbcConnectionManager(ConnectionManagerType, OdbcConnectionString)
Declaration
public OdbcConnectionManager(ConnectionManagerType connectionType, OdbcConnectionString connectionString)
Parameters
| Type | Name | Description |
|---|---|---|
| ConnectionManagerType | connectionType | |
| OdbcConnectionString | connectionString |
OdbcConnectionManager(ConnectionManagerType, string)
Declaration
public OdbcConnectionManager(ConnectionManagerType connectionType, string connectionString)
Parameters
| Type | Name | Description |
|---|---|---|
| ConnectionManagerType | connectionType | |
| string | connectionString |
OdbcConnectionManager(ConnectionManagerType)
Declaration
public OdbcConnectionManager(ConnectionManagerType connectionType)
Parameters
| Type | Name | Description |
|---|---|---|
| ConnectionManagerType | connectionType |
Properties
ConnectionManagerType
The database type for the connection manager.
Declaration
public override ConnectionManagerType ConnectionManagerType { get; protected set; }
Property Value
| Type | Description |
|---|---|
| ConnectionManagerType |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.ConnectionManagerType
IsOdbcOrOleDbConnection
Indicates if the current connection manager is used as a OleDb or Odbc Connection.
Declaration
public override bool IsOdbcOrOleDbConnection { get; }
Property Value
| Type | Description |
|---|---|
| bool |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.IsOdbcOrOleDbConnection
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 |
|---|---|
| string |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.QB
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 |
|---|---|
| string |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.QE
Methods
BulkDelete(ITableData)
Performs a bulk delete
Declaration
public override void BulkDelete(ITableData data)
Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | Batch of data |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkDelete(ETLBox.ControlFlow.ITableData)
BulkInsert(ITableData)
Performs a bulk insert
Declaration
public override void BulkInsert(ITableData data)
Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | Batch of data |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkInsert(ETLBox.ControlFlow.ITableData)
BulkSelect(ITableData, ICollection<string>, Action, Action, params Action<object>[])
Declaration
public override void BulkSelect(ITableData data, ICollection<string> selectColumnNames, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] rowActions)
Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | |
| System.Collections.Generic.ICollection<T><string> | selectColumnNames | |
| System.Action | beforeRowReadAction | |
| System.Action | afterRowReadAction | |
| System.Action<T><object>[] | rowActions |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkSelect(ETLBox.ControlFlow.ITableData, System.Collections.Generic.ICollection<string>, System.Action, System.Action, params System.Action<object>[])
BulkUpdate(ITableData, ICollection<string>, ICollection<string>)
Performs a bulk update
Declaration
public override void BulkUpdate(ITableData data, ICollection<string> setColumnNames, ICollection<string> joinColumnNames)
Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | Batch of data |
| System.Collections.Generic.ICollection<T><string> | setColumnNames | The column names used in the set part of the update statement |
| System.Collections.Generic.ICollection<T><string> | joinColumnNames | The column names to join for the update |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkUpdate(ETLBox.ControlFlow.ITableData, System.Collections.Generic.ICollection<string>, System.Collections.Generic.ICollection<string>)
CleanUpBulkInsert(string)
Called after the whole bulk insert operation to change back settings made to improve bulk insert performance
Declaration
public override void CleanUpBulkInsert(string tablename)
Parameters
| Type | Name | Description |
|---|---|---|
| string | tablename |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.CleanUpBulkInsert(string)
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 |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.Clone()
PrepareBulkInsert(string)
Performs preparations needed to improved performance of a bulk insert operation
Declaration
public override void PrepareBulkInsert(string tablename)
Parameters
| Type | Name | Description |
|---|---|---|
| string | tablename |
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.PrepareBulkInsert(string)
Implements
System.IDisposable