Namespace ETLBox.Connection

Classes

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.

DbConnectionManager<Connection>

DbConnectionString<T, TBuilder>

IDbConnectionString base

MySqlConnectionManager

Connection manager of a classic ADO.NET connection to a (Microsoft) Sql Server.

MySqlConnectionString

A helper class for encapsulating a conection string to a MySql server in an object. Internally the MySqlConnectionStringBuilder is used to access the values of the given connection string.

MySqlOdbcConnectionManager

MySql Connection manager for an ODBC connection based on ADO.NET to Sql Server. ODBC by default does not support a Bulk Insert - inserting big amounts of data is translated into a

insert into (...) values (..),(..),(..) statementes.

This means that inserting big amounts of data in a database via Odbc can be much slower than using the native connector. Also be careful with the batch size - some databases have limitations regarding the length of sql statements. Reduce the batch size if you encounter issues here.

OdbcConnectionManager

OdbcConnectionString

A helper class for encapsulating a conection string in an object. Internally the OdbcConnectionStringBuilder is used to access the values of the given connection string.

PostgresConnectionManager

Connection manager of a classic ADO.NET connection to a (Microsoft) Sql Server.

PostgresConnectionString

A helper class for encapsulating a conection string to a MySql server in an object. Internally the MySqlConnectionStringBuilder is used to access the values of the given connection string.

PostgresOdbcConnectionManager

Postgres Connection manager for an ODBC connection based on ADO.NET to Sql Server. ODBC by default does not support a Bulk Insert - inserting big amounts of data is translated into a

insert into (...) values (..),(..),(..) statementes.

This means that inserting big amounts of data in a database via Odbc can be much slower than using the native connector. Also be careful with the batch size - some databases have limitations regarding the length of sql statements. Reduce the batch size if you encounter issues here.

SqlConnectionManager

Connection manager of a classic ADO.NET connection to a (Microsoft) Sql Server.

SqlConnectionString

A helper class for encapsulating a conection string to a sql server in an object. Internally the SqlConnectionStringBuilder is used to access the values of the given connection string.

SQLiteConnectionManager

Connection manager for an SQLite connection based on ADO.NET.

SQLiteConnectionString

A helper class for encapsulating a conection string in an object. Internally the SQLiteConnectionStringBuilder is used to access the values of the given connection string.

SqlOdbcConnectionManager

Sql Server Connection manager for an ODBC connection based on ADO.NET to Sql Server. ODBC by default does not support a Bulk Insert - inserting big amounts of data is translated into a

insert into (...) values (..),(..),(..) statementes.

This means that inserting big amounts of data in a database via Odbc can be much slower than using the native connector. Also be careful with the batch size - some databases have limitations regarding the length of sql statements. Reduce the batch size if you encounter issues here.

Interfaces

IConnectionManager

IDbConnectionString

The generic defintion of a connection string

Enums

ConnectionManagerType