Class MySqlOdbcConnectionManager
MySql Connection manager for an ODBC connection. 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.
Inheritance
object
MySqlOdbcConnectionManager
Inherited Members
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BeginTransaction(IsolationLevel)
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: ETLBox.Odbc
Assembly: ETLBox.Odbc.dll
Syntax
public class MySqlOdbcConnectionManager : OdbcConnectionManager, IConnectionManager<OdbcConnection, OdbcTransaction>, IConnectionManager, IDisposable
Constructors
MySqlOdbcConnectionManager()
Declaration
public MySqlOdbcConnectionManager()
MySqlOdbcConnectionManager(OdbcConnectionString)
Declaration
public MySqlOdbcConnectionManager(OdbcConnectionString connectionString)
Parameters
Type | Name | Description |
---|---|---|
OdbcConnectionString | connectionString |
MySqlOdbcConnectionManager(string)
Declaration
public MySqlOdbcConnectionManager(string connectionString)
Parameters
Type | Name | Description |
---|---|---|
string | connectionString |
Properties
SupportSchemas
Indicates if the database supports schemas In MySql, this is false because the schema here is a database in ETLBox. Use SupportDatabases instead
Declaration
public override bool SupportSchemas { get; }
Property Value
Type | Description |
---|---|
bool |
Overrides
ETLBox.DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.SupportSchemas
Methods
Clone()
Cretes a clone of the current connection manager
Declaration
public override IConnectionManager Clone()
Returns
Type | Description |
---|---|
IConnectionManager | A instance copy of the current connection manager |
Overrides
Implements
System.IDisposable