Class OdbcConnectionManager
Inheritance
Implements
Inherited Members
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(OdbcConnectionString)
Declaration
public OdbcConnectionManager(OdbcConnectionString connectionString)
Parameters
Type | Name | Description |
---|---|---|
OdbcConnectionString | connectionString |
Properties
ConnectionManagerType
The database type for the connection manager.
Declaration
public override ConnectionManagerType ConnectionManagerType { get; protected set; }
Property Value
Type | Description |
---|---|
ConnectionManagerType |
Overrides
IsOdbcOrOleDbConnection
Indicates if the current connection mangager is used as a OleDb or Odbc Connection.
Declaration
public override bool IsOdbcOrOleDbConnection { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
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
Methods
BulkDelete(ITableData)
Performs a bulk delete
Declaration
public override void BulkDelete(ITableData data)
Parameters
Type | Name | Description |
---|---|---|
ITableData | data | Batch of data |
Overrides
BulkInsert(ITableData)
Performs a bulk insert
Declaration
public override void BulkInsert(ITableData data)
Parameters
Type | Name | Description |
---|---|---|
ITableData | data | Batch of data |
Overrides
BulkSelect(ITableData, ICollection<String>, Action, Action, 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<System.String> | selectColumnNames | |
System.Action | beforeRowReadAction | |
System.Action | afterRowReadAction | |
System.Action<System.Object>[] | rowActions |
Overrides
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<System.String> | setColumnNames | |
System.Collections.Generic.ICollection<System.String> | joinColumnNames |
Overrides
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 |
---|---|---|
System.String | tablename |
Overrides
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
OverrideConnectionSpecifics(ConnectionManagerType, String, String, String)
Changes the connection manager type for the generic connector, so that you can try to use it with not supported setups. If you are looking for supported Odbc connection managers, try to use the specific connection managers (e.g. MySqlOdbcConnectionManager for MySql or PostgresOdbcConnectionManager for Postgres)
Declaration
public void OverrideConnectionSpecifics(ConnectionManagerType connectionManagerType, string QB, string QE, string PP = "@")
Parameters
Type | Name | Description |
---|---|---|
ConnectionManagerType | connectionManagerType | The new connection type for this connection manager. |
System.String | QB | Quotation begin (e.g. "`" for MySql or "[" for SqlServer) |
System.String | QE | Quotation end (e.g. "`" for MySql or "]" for SqlServer) |
System.String | PP | Parameter placeholder ("@" for most databases) |
PrepareBulkInsert(String)
Performs preparations needed to improved performance of a bulk insert operation
Declaration
public override void PrepareBulkInsert(string tablename)
Parameters
Type | Name | Description |
---|---|---|
System.String | tablename |