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
System.Object
DbConnectionManager<System.Data.Odbc.OdbcConnection>
OdbcConnectionManager
AccessOdbcConnectionManager
Implements
System.IDisposable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.Connection
Assembly: ETLBox.Odbc.dll
Syntax
public class AccessOdbcConnectionManager : OdbcConnectionManager, IConnectionManager, IDisposable
Examples
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
System.String connectionString

Properties

ConnectionManagerType

Declaration
public override ConnectionManagerType ConnectionManagerType { get; }
Property Value
Type Description
ConnectionManagerType
Overrides

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
System.String

PreparationDone

Declaration
protected bool PreparationDone { get; set; }
Property Value
Type Description
System.Boolean

QB

Declaration
public override string QB { get; }
Property Value
Type Description
System.String
Overrides

QE

Declaration
public override string QE { get; }
Property Value
Type Description
System.String
Overrides

SupportComputedColumns

Declaration
public override bool SupportComputedColumns { get; }
Property Value
Type Description
System.Boolean
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection>.SupportComputedColumns

SupportDatabases

Declaration
public override bool SupportDatabases { get; }
Property Value
Type Description
System.Boolean
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection>.SupportDatabases

SupportProcedures

Declaration
public override bool SupportProcedures { get; }
Property Value
Type Description
System.Boolean
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection>.SupportProcedures

SupportSchemas

Declaration
public override bool SupportSchemas { get; }
Property Value
Type Description
System.Boolean
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection>.SupportSchemas

Methods

AfterBulkInsert(String)

Declaration
public override void AfterBulkInsert(string tableName)
Parameters
Type Name Description
System.String tableName
Overrides

BeforeBulkInsert(String)

Declaration
public override void BeforeBulkInsert(string tableName)
Parameters
Type Name Description
System.String tableName
Overrides

BulkInsert(ITableData, String)

Declaration
public override void BulkInsert(ITableData data, string tableName)
Parameters
Type Name Description
ITableData data
System.String tableName
Overrides

CheckIfTableOrViewExists(String)

Declaration
public override bool CheckIfTableOrViewExists(string unquotatedFullName)
Parameters
Type Name Description
System.String unquotatedFullName
Returns
Type Description
System.Boolean
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection>.CheckIfTableOrViewExists(System.String)

CleanUpBulkInsert(String)

Declaration
public override void CleanUpBulkInsert(string tablename)
Parameters
Type Name Description
System.String tablename
Overrides

Clone()

Declaration
public override IConnectionManager Clone()
Returns
Type Description
IConnectionManager
Overrides

PrepareBulkInsert(String)

Declaration
public override void PrepareBulkInsert(string tablename)
Parameters
Type Name Description
System.String tablename
Overrides

ReadTableDefinition(ObjectNameDescriptor)

Declaration
public override TableDefinition ReadTableDefinition(ObjectNameDescriptor TN)
Parameters
Type Name Description
ObjectNameDescriptor TN
Returns
Type Description
TableDefinition
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection>.ReadTableDefinition(ETLBox.Helper.ObjectNameDescriptor)

Implements

System.IDisposable