Class OdbcConnectionManager
Generic OdbcConnectionManager - try this connection manager if no particular connection manager for your database exists. E.g. for MySql use the MySqlOdbcConnectionManager. Make sure to set the ConnectionType to fit with your database when creating an instance. If you leave the ConnectionManagerType.Unknown (which is the default), there might be some limitations when you use this ConnectionManager:
- Most ControlFlow Tasks won't work properly, depending on your database
- SqlTask will work
- If you use special characters, you need to set the quotation begin / quotation end properties QB and QE that fit to your database (e.g. "[" and "]" for Sql Server or "`" for MySql)
- DbDestination and DbSource will only work if you provide a TableDefinition that at least define the table and the columns names
Inheritance
OdbcConnectionManager
Inherited Members
Namespace: ETLBox.Odbc
Assembly: ETLBox.Odbc.dll
Syntax
{{< /rawhtml >}} ```C# public class OdbcConnectionManager : DbConnectionManagerConstructors
OdbcConnectionManager()
Declaration
{{< /rawhtml >}} ```C# public OdbcConnectionManager() ``` {{< rawhtml >}}OdbcConnectionManager(ConnectionType)
Declaration
{{< /rawhtml >}} ```C# public OdbcConnectionManager(ConnectionType connectionType) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| ConnectionType | connectionType |
OdbcConnectionManager(ConnectionType, OdbcConnectionString)
Declaration
{{< /rawhtml >}} ```C# public OdbcConnectionManager(ConnectionType connectionType, OdbcConnectionString connectionString) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| ConnectionType | connectionType | |
| OdbcConnectionString | connectionString |
OdbcConnectionManager(ConnectionType, string)
Declaration
{{< /rawhtml >}} ```C# public OdbcConnectionManager(ConnectionType connectionType, string connectionString) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| ConnectionType | connectionType | |
| string | connectionString |
Properties
ConnectionTimeout
Set the connetion timeout for the ODBC connection.
Declaration
{{< /rawhtml >}} ```C# public int ConnectionTimeout { get; set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| int |
ConnectionType
The database type for the connection manager.
Declaration
{{< /rawhtml >}} ```C# public override ConnectionType ConnectionType { get; protected set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| ConnectionType |
Overrides
ETLBox.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.ConnectionType
IsOdbcOrOleDbConnection
Indicates if the current connection manager is used as a OleDb or Odbc Connection.
Declaration
{{< /rawhtml >}} ```C# public override bool IsOdbcOrOleDbConnection { get; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| bool |
Overrides
ETLBox.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.IsOdbcOrOleDbConnection
QB
The quotation begin character that is used in the database. E.g. SqlServer uses: '[' and Postgres: '"'
Declaration
{{< /rawhtml >}} ```C# public override string QB { get; protected set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| string |
Overrides
ETLBox.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.QB
QE
The quotation end character that is used in the database. E.g. SqlServer uses: ']' and Postgres: '"'
Declaration
{{< /rawhtml >}} ```C# public override string QE { get; protected set; } ``` {{< rawhtml >}}Property Value
| Type | Description |
|---|---|
| string |
Overrides
ETLBox.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.QE
Methods
BulkDelete(ITableData)
Performs a bulk delete
Declaration
{{< /rawhtml >}} ```C# public override void BulkDelete(ITableData data) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | Batch of data |
Overrides
ETLBox.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkDelete(ETLBox.ITableData)
BulkInsert(ITableData)
Performs a bulk insert
Declaration
{{< /rawhtml >}} ```C# public override void BulkInsert(ITableData data) ``` {{< rawhtml >}}Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | Batch of data |
Overrides
ETLBox.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkInsert(ETLBox.ITableData)
BulkSelect(ITableData, ICollection<string>, Action, Action, params Action<object>[])
Performs a bulk select