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