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.

AdomdConnectionManager

Connection manager for Adomd connection to a sql server analysis server.

Db2ConnectionManager

Connection manager of a ETLBox connection to a Db2 Server. Uses the official Db2 ADO.NET driver for .NET Core.

Db2ConnectionString

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

DbConnectionManager<Connection>

The generic implementation on which all connection managers are based on

DbConnectionString<T, TBuilder>

IDbConnectionString base

MariaDbConnectionManager

Connection manager of a ETLBox connection to Maria DB.

MariaDbConnectionString

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

MySqlConnectionManager

Connection manager of a ETLBox connection to a MySql Server. Uses the official MySql ADO.NET driver for .NET.

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 (..),(..),(..) statements.

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.

OleDbConnectionManager

OleDbConnectionString

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.

OracleConnectionManager

Connection manager of an ETLBox connection to an Oracle database. Usess the official Oracle ADO.NET driver for .NET core.

OracleConnectionString

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

OracleOdbcConnectionManager

Oracle 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 (..),(..),(..) statements.

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.

PostgresConnectionManager

Connection manager that describes an ETLBox connection to a Postgres 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 (..),(..),(..) statements.

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 (..),(..),(..) statements.

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.

SqlOleDbConnectionManager

Sql Server Connection manager for an OleDb connection to Sql Server.

Interfaces

IConnectionManager

Common properties and methods for all database connection managers

IDbConnectionString

The generic defintion of a connection string

Enums

ConnectionManagerType

All databases types that ETLBox supports with Connection Managers