Class OdbcConnectionManager
Inheritance
Inherited Members
Namespace: ETLBox.Connection
Assembly: ETLBox.Odbc.dll
Syntax
public class OdbcConnectionManager : DbConnectionManager<OdbcConnection>, 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; }
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; }
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; }
Property Value
Type | Description |
---|---|
System.String |
Overrides
Methods
AfterBulkInsert(String)
Called after every bulk insert of a batch
Declaration
public override void AfterBulkInsert(string tableName)
Parameters
Type | Name | Description |
---|---|---|
System.String | tableName | Destination table name |
Overrides
BeforeBulkInsert(String)
Called before every bulk insert of a batch
Declaration
public override void BeforeBulkInsert(string tableName)
Parameters
Type | Name | Description |
---|---|---|
System.String | tableName | Destination table name |
Overrides
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 (all batches)
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
OdbcBulkInsert(BulkSqlGenerator<OdbcParameter>)
Declaration
protected void OdbcBulkInsert(BulkSqlGenerator<OdbcParameter> bulkInsert)
Parameters
Type | Name | Description |
---|---|---|
BulkSqlGenerator<System.Data.Odbc.OdbcParameter> | bulkInsert |
PrepareBulkInsert(String)
Called before the whole bulk insert operation (all batches)
Declaration
public override void PrepareBulkInsert(string tablename)
Parameters
Type | Name | Description |
---|---|---|
System.String | tablename |