ETLBox
Title here
Summary here
AccessOdbcConnectionManager
Class AccessOdbcConnectionManager
Connection manager for an ODBC connection to Access databases. This connection manager also is based on ADO.NET. ODBC by default does not support a Bulk Insert - and Access does not support the insert into (...) values (...),(...),(...) syntax. So the following syntax is used
insert into (Col1, Col2,...)
select * from (
select 'Val1' as Col1 from dummytable
union all
select 'Val2' as Col2 from dummytable
...
) a;The dummytable is a special helper table containing only one record.
Inheritance
AccessOdbcConnectionManager
Inherited Members
Namespace: ETLBox.Odbc
Assembly: ETLBox.Odbc.dll
Syntax
public class AccessOdbcConnectionManager : OdbcConnectionManager, IConnectionManager<OdbcConnection, OdbcTransaction>, IConnectionManager, IDisposableExamples
ControlFlow.DefaultDbConnection =
new AccessOdbcConnectionManager(new OdbcConnectionString(
"Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\DB\Test.mdb"));Constructors
AccessOdbcConnectionManager()
Declaration
public AccessOdbcConnectionManager()AccessOdbcConnectionManager(OdbcConnectionString)
Declaration
public AccessOdbcConnectionManager(OdbcConnectionString connectionString)Parameters
| Type | Name | Description |
|---|---|---|
| OdbcConnectionString | connectionString |
AccessOdbcConnectionManager(string)
Declaration
public AccessOdbcConnectionManager(string connectionString)Parameters
| Type | Name | Description |
|---|---|---|
| string | connectionString |
Properties
DummyTableName
Helper table that needs to be created in order to simulate bulk inserts. Contains only 1 record and is only temporarily created.
Declaration
public string DummyTableName { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Methods
BulkInsert(ITableData)
Performs a bulk insert
Declaration
public override void BulkInsert(ITableData data)Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | Batch of data |
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 |
|---|---|---|
| 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
GetSchema(string)
Declaration
public override TableDefinition GetSchema(string tableName)Parameters
| Type | Name | Description |
|---|---|---|
| string | tableName |
Returns
| Type | Description |
|---|---|
| TableDefinition |
Overrides
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 |