• Getting started
  • API Documentation
  • Pricing
  • Contact
Show / Hide Table of Contents
  • ETLBox.Connection
    • AccessOdbcConnectionManager
    • AdomdConnectionManager
    • ConnectionManagerType
    • Db2ConnectionManager
    • Db2ConnectionString
    • DbConnectionManager<Connection>
    • DbConnectionString<T, TBuilder>
    • IConnectionManager
    • IDbConnectionString
    • MariaDbConnectionManager
    • MariaDbConnectionString
    • MySqlConnectionManager
    • MySqlConnectionString
    • MySqlOdbcConnectionManager
    • OdbcConnectionManager
    • OdbcConnectionString
    • OleDbConnectionManager
    • OleDbConnectionString
    • OracleConnectionManager
    • OracleConnectionString
    • OracleOdbcConnectionManager
    • PostgresConnectionManager
    • PostgresConnectionString
    • PostgresOdbcConnectionManager
    • SqlConnectionManager
    • SqlConnectionString
    • SQLiteConnectionManager
    • SQLiteConnectionString
    • SqlOdbcConnectionManager
    • SqlOleDbConnectionManager
  • ETLBox.ControlFlow
    • ControlFlow
    • ControlFlowTask
    • DbTask
    • DropTask<T>
    • IfExistsTask
    • ILoggableTask
    • ITableData
    • LoggableTask
    • ProcedureDefinition
    • ProcedureParameter
    • QueryParameter
    • TableColumn
    • TableData
    • TableData<T>
    • TableDefinition
  • ETLBox.ControlFlow.Tasks
    • CalculateDatabaseHashTask
    • CleanUpSchemaTask
    • CreateDatabaseTask
    • CreateIndexTask
    • CreateProcedureTask
    • CreateSchemaTask
    • CreateTableTask
    • CreateViewTask
    • DropDatabaseTask
    • DropIndexTask
    • DropProcedureTask
    • DropSchemaTask
    • DropTableTask
    • DropViewTask
    • GetDatabaseListTask
    • IfDatabaseExistsTask
    • IfIndexExistsTask
    • IfProcedureExistsTask
    • IfSchemaExistsTask
    • IfTableOrViewExistsTask
    • RecoveryModel
    • RowCountOptions
    • RowCountTask
    • SqlTask
    • TruncateTableTask
    • XmlaTask
  • ETLBox.DataFlow
    • AggregateColumn
    • ChangeAction
    • ColumnMap
    • CompareColumn
    • DataFlow
    • DataFlowBatchDestination<TInput>
    • DataFlowComponent
    • DataFlowDestination<TInput>
    • DataFlowExecutableSource<TOutput>
    • DataFlowJoinTarget<TInput>
    • DataFlowSource<TOutput>
    • DataFlowStreamDestination<TInput>
    • DataFlowStreamSource<TOutput>
    • DataFlowTransformation<TInput, TOutput>
    • DeleteColumn
    • DistinctColumn
    • ErrorSource
    • ETLBoxError
    • ExcelColumn
    • ExcelRange
    • GroupColumn
    • ICacheManager<TInput, TCache>
    • IDataFlowBatchDestination
    • IDataFlowBatchDestination<TInput>
    • IDataFlowComponent
    • IDataFlowDestination
    • IDataFlowDestination<TInput>
    • IDataFlowExecutableSource
    • IDataFlowExecutableSource<TOutput>
    • IDataFlowLogging
    • IDataFlowSource
    • IDataFlowSource<TOutput>
    • IDataFlowStreamDestination
    • IDataFlowStreamDestination<TInput>
    • IDataFlowStreamSource
    • IDataFlowStreamSource<TOutput>
    • IDataFlowTransformation<TInput, TOutput>
    • IDataFlowTransformation<TOutput>
    • IdColumn
    • IMergeableRow
    • JoinTarget<TInput>
    • MatchColumn
    • MemoryCache<TInput, TCache>
    • MergeableRow
    • MergeMode
    • MergeProperties
    • Network
    • ResourceType
    • RetrieveColumn
    • StreamMetaData
    • TypeInfo
    • UpdateColumn
  • ETLBox.DataFlow.Connectors
    • ConcurrentMemoryDestination
    • ConcurrentMemoryDestination<TInput>
    • CsvDestination
    • CsvDestination<TInput>
    • CsvSource
    • CsvSource<TOutput>
    • CustomBatchDestination
    • CustomBatchDestination<TInput>
    • CustomBatchSource
    • CustomBatchSource<TOutput>
    • CustomDestination
    • CustomDestination<TInput>
    • CustomSource
    • CustomSource<TOutput>
    • DbDestination
    • DbDestination<TInput>
    • DbMerge
    • DbMerge<TInput>
    • DbSource
    • DbSource<TOutput>
    • ExcelSource
    • ExcelSource<TOutput>
    • JsonDestination
    • JsonDestination<TInput>
    • JsonSource
    • JsonSource<TOutput>
    • MemoryDestination
    • MemoryDestination<TInput>
    • MemorySource
    • MemorySource<TOutput>
    • TextDestination
    • TextDestination<TInput>
    • TextSource
    • TextSource<TOutput>
    • VoidDestination
    • VoidDestination<TInput>
    • XmlDestination
    • XmlDestination<TInput>
    • XmlSource
    • XmlSource<TOutput>
  • ETLBox.DataFlow.Transformations
    • Aggregation
    • Aggregation<TInput, TOutput>
    • AggregationMethod
    • BatchTransformation
    • BatchTransformation<TInput, TOutput>
    • BatchTransformation<TInput>
    • BlockTransformation
    • BlockTransformation<TInput, TOutput>
    • BlockTransformation<TInput>
    • CachedBatchTransformation
    • CachedBatchTransformation<TInput, TOutput, TCache>
    • CachedBatchTransformation<TInput, TOutput>
    • CachedBatchTransformation<TInput>
    • CachedRowTransformation
    • CachedRowTransformation<TInput, TOutput, TCache>
    • CachedRowTransformation<TInput, TOutput>
    • CachedRowTransformation<TInput>
    • CacheMode
    • ColumnRename
    • ColumnRename<TInput>
    • CrossJoin
    • CrossJoin<TInput>
    • CrossJoin<TInput1, TInput2, TOutput>
    • CrossJoin<TInput1, TInput2, TOutput>.InMemoryDestination<TInput>
    • Distinct<TInput>
    • LookupTransformation
    • LookupTransformation<TInput, TSource>
    • LookupTransformation<TInput, TSource>.PartialDbCacheSettings
    • MergeJoin
    • MergeJoin<TInput>
    • MergeJoin<TInput1, TInput2, TOutput>
    • Multicast
    • Multicast<TInput>
    • RowDuplication
    • RowDuplication<TInput>
    • RowMultiplication
    • RowMultiplication<TInput, TOutput>
    • RowMultiplication<TInput>
    • RowTransformation
    • RowTransformation<TInput, TOutput>
    • RowTransformation<TInput>
    • Sort
    • Sort<TInput>
    • XmlSchemaValidation
    • XmlSchemaValidation<TInput>
  • ETLBox.Exceptions
    • ETLBoxException
    • ETLBoxFaultedBufferException
    • ETLBoxNotSupportedException
  • ETLBox.Helper
    • BatchLinq
    • BulkSqlGenerator<T>
    • DataTypeConverter
    • ExpandoJsonPathConverter
    • HashHelper
    • IDataTypeConverter
    • JsonPathConverter
    • JsonProperty2JsonPath
    • JsonProperty2JsonPath.MultipleResultsInPath
    • ObjectNameDescriptor
    • PropertyInfoExtension
    • SqlParser
    • StringExtension
  • ETLBox.Logging
    • AbortLoadProcessTask
    • CreateErrorTableTask
    • CreateLoadProcessTableTask
    • CreateLogTableTask
    • CustomTask
    • EndLoadProcessTask
    • ETLLogLayoutRenderer
    • GetLoadProcessAsJSONTask
    • GetLogAsJSONTask
    • LoadProcess
    • LogEntry
    • Logging
    • LogHierarchyEntry
    • LogTask
    • Package
    • ReadLoadProcessTableTask
    • ReadLogTableTask
    • ReadOptions
    • Sequence
    • Sequence<T>
    • StartLoadProcessTask

Class 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.

Inheritance
System.Object
DbConnectionManager<System.Data.Odbc.OdbcConnection>
OdbcConnectionManager
MySqlOdbcConnectionManager
Implements
IConnectionManager
System.IDisposable
Inherited Members
OdbcConnectionManager.IsOdbcOrOleDbConnection
OdbcConnectionManager.OdbcBulkInsert(BulkSqlGenerator<OdbcParameter>)
OdbcConnectionManager.BulkInsert(ITableData)
OdbcConnectionManager.BulkDelete(ITableData)
OdbcConnectionManager.BulkUpdate(ITableData, ICollection<String>, ICollection<String>)
OdbcConnectionManager.BulkSelect(ITableData, ICollection<String>, Action, Action, Action<Object>[])
OdbcConnectionManager.BeforeBulkInsert(String)
OdbcConnectionManager.AfterBulkInsert(String)
OdbcConnectionManager.PrepareBulkInsert(String)
OdbcConnectionManager.CleanUpBulkInsert(String)
DbConnectionManager<OdbcConnection>.DbConnection
DbConnectionManager<OdbcConnection>.MaxLoginAttempts
DbConnectionManager<OdbcConnection>.LeaveOpen
DbConnectionManager<OdbcConnection>.ConnectionString
DbConnectionManager<OdbcConnection>.State
DbConnectionManager<OdbcConnection>.Transaction
DbConnectionManager<OdbcConnection>.IsInBulkInsert
DbConnectionManager<OdbcConnection>.PP
DbConnectionManager<OdbcConnection>.SupportDatabases
DbConnectionManager<OdbcConnection>.SupportProcedures
DbConnectionManager<OdbcConnection>.SupportComputedColumns
DbConnectionManager<OdbcConnection>.DoPrepareCommand
DbConnectionManager<OdbcConnection>.MaxParameterAmount
DbConnectionManager<OdbcConnection>.ReadTableDefinition(ObjectNameDescriptor)
DbConnectionManager<OdbcConnection>.CheckIfTableOrViewExists(String)
DbConnectionManager<OdbcConnection>.CreateCommand(String, IEnumerable<QueryParameter>)
DbConnectionManager<OdbcConnection>.ExecuteNonQuery(String, IEnumerable<QueryParameter>)
DbConnectionManager<OdbcConnection>.ExecuteScalar(String, IEnumerable<QueryParameter>)
DbConnectionManager<OdbcConnection>.ExecuteReader(String, IEnumerable<QueryParameter>)
DbConnectionManager<OdbcConnection>.BeginTransaction(IsolationLevel)
DbConnectionManager<OdbcConnection>.BeginTransaction()
DbConnectionManager<OdbcConnection>.CommitTransaction()
DbConnectionManager<OdbcConnection>.RollbackTransaction()
DbConnectionManager<OdbcConnection>.CloneIfAllowed()
DbConnectionManager<OdbcConnection>.Open()
DbConnectionManager<OdbcConnection>.CreateDbConnection()
DbConnectionManager<OdbcConnection>.Close()
DbConnectionManager<OdbcConnection>.CloseIfAllowed()
DbConnectionManager<OdbcConnection>.Dispose(Boolean)
DbConnectionManager<OdbcConnection>.Dispose()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.Connection
Assembly: ETLBox.Odbc.dll
Syntax
public class MySqlOdbcConnectionManager : OdbcConnectionManager, 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
System.String connectionString

Properties

ConnectionManagerType

The database type for the connection manager.

Declaration
public override ConnectionManagerType ConnectionManagerType { get; }
Property Value
Type Description
ConnectionManagerType
Overrides
OdbcConnectionManager.ConnectionManagerType

QB

The quotation begin character that is used in the database. E.g. SqlServer uses: '[' and Postgres: '"'

Declaration
public override string QB { get; }
Property Value
Type Description
System.String
Overrides
OdbcConnectionManager.QB

QE

The quotation end character that is used in the database. E.g. SqlServer uses: ']' and Postgres: '"'

Declaration
public override string QE { get; }
Property Value
Type Description
System.String
Overrides
OdbcConnectionManager.QE

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
System.Boolean
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection>.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
OdbcConnectionManager.Clone()

Implements

IConnectionManager
System.IDisposable
Back to top Crafted with <3 in Berlin
Contact & legal notice