• Getting started
  • API Documentation
  • Pricing
  • Contact
Show / Hide Table of Contents
  • ETLBox.Connection
    • AccessOdbcConnectionManager
    • AdomdConnectionManager
    • ConnectionManagerType
    • Db2ConnectionManager
    • Db2ConnectionString
    • DbConnectionManager<TConnection, TTransaction, TParameter>
    • DbConnectionString<T, TBuilder>
    • IConnectionManager
    • IConnectionManager<TConnection, TTransaction>
    • IConnectionManagerDbObjects
    • 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
    • TableDefinition
  • ETLBox.ControlFlow.Tasks
    • CleanUpSchemaTask
    • CreateDatabaseTask
    • CreateIndexTask
    • CreateProcedureTask
    • CreateSchemaTask
    • CreateTableTask
    • CreateViewTask
    • DropDatabaseTask
    • DropIndexTask
    • DropProcedureTask
    • DropSchemaTask
    • DropTableTask
    • DropViewTask
    • GetDatabaseListTask
    • GetListTask
    • GetTableListTask
    • GetViewListTask
    • 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
    • GenericTypeInfo
    • 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
    • PropertyAttributes
    • RenameColumn
    • ResourceType
    • RetrieveColumn
    • StreamMetaData
    • TypeInfo
    • UpdateColumn
  • ETLBox.DataFlow.Connectors
    • ColumnConverter
    • 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
    • BulkSqlGenerator<T>
    • DataTypeConverter
    • ExpandoJsonPathConverter
    • HashHelper
    • IDataTypeConverter
    • JsonPathConverter
    • JsonProperty2JsonPath
    • JsonProperty2JsonPath.MultipleResultsInPath
    • ListExtensions
    • 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 OdbcConnectionManager

Inheritance
System.Object
DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>
OdbcConnectionManager
AccessOdbcConnectionManager
MySqlOdbcConnectionManager
OracleOdbcConnectionManager
PostgresOdbcConnectionManager
SqlOdbcConnectionManager
Implements
IConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction>
IConnectionManager
System.IDisposable
Inherited Members
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.DbConnection
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.ConnectionManagerType
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.MaxLoginAttempts
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.LeaveOpen
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.ConnectionString
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.State
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.Transaction
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.IsInBulkInsert
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.QB
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.QE
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.PP
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.SupportDatabases
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.SupportProcedures
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.SupportSchemas
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.IsOdbcOrOleDbConnection
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.DoPrepareCommand
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.DisablePreparationForNextExecution
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.MaxParameterAmount
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BulkNonQuery(String, IEnumerable<OdbcParameter>)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BulkReader(String, IEnumerable<OdbcParameter>, Action, Action, Action<Object>[])
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.ExecuteNonQuery(String, IEnumerable<QueryParameter>)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.ExecuteScalar(String, IEnumerable<QueryParameter>)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.ExecuteReader(String, IEnumerable<QueryParameter>)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BeginTransaction(IsolationLevel)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BeginTransaction()
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.CommitTransaction()
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.RollbackTransaction()
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.PrepareBulkInsert(String)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BulkInsert(ITableData)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.CleanUpBulkInsert(String)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BulkDelete(ITableData)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BulkUpdate(ITableData, ICollection<String>, ICollection<String>)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.BulkSelect(ITableData, ICollection<String>, Action, Action, Action<Object>[])
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.CloneIfAllowed()
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.Clone()
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.CopyBaseAttributes(DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.Open()
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.CreateDbConnection()
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.Close()
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.CloseIfAllowed()
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.Dispose(Boolean)
DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>.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 OdbcConnectionManager : DbConnectionManager<OdbcConnection, OdbcTransaction, OdbcParameter>, IConnectionManager<OdbcConnection, OdbcTransaction>, IConnectionManager, IDisposable

Constructors

OdbcConnectionManager()

Declaration
public OdbcConnectionManager()

OdbcConnectionManager(OdbcConnectionString)

Declaration
public OdbcConnectionManager(OdbcConnectionString connectionString)
Parameters
Type Name Description
OdbcConnectionString connectionString

Properties

ConnectionManagerType

The database type for the connection manager.

Declaration
public override ConnectionManagerType ConnectionManagerType { get; protected set; }
Property Value
Type Description
ConnectionManagerType
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.ConnectionManagerType

IsOdbcOrOleDbConnection

Indicates if the current connection mangager is used as a OleDb or Odbc Connection.

Declaration
public override bool IsOdbcOrOleDbConnection { get; }
Property Value
Type Description
System.Boolean
Overrides
ETLBox.Connection.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
public override string QB { get; protected set; }
Property Value
Type Description
System.String
Overrides
ETLBox.Connection.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
public override string QE { get; protected set; }
Property Value
Type Description
System.String
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.QE

Methods

BulkDelete(ITableData)

Performs a bulk delete

Declaration
public override void BulkDelete(ITableData data)
Parameters
Type Name Description
ITableData data

Batch of data

Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkDelete(ETLBox.ControlFlow.ITableData)

BulkInsert(ITableData)

Performs a bulk insert

Declaration
public override void BulkInsert(ITableData data)
Parameters
Type Name Description
ITableData data

Batch of data

Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkInsert(ETLBox.ControlFlow.ITableData)

BulkSelect(ITableData, ICollection<String>, Action, Action, Action<Object>[])

Declaration
public override void BulkSelect(ITableData data, ICollection<string> selectColumnNames, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] rowActions)
Parameters
Type Name Description
ITableData data
System.Collections.Generic.ICollection<System.String> selectColumnNames
System.Action beforeRowReadAction
System.Action afterRowReadAction
System.Action<System.Object>[] rowActions
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkSelect(ETLBox.ControlFlow.ITableData, System.Collections.Generic.ICollection<System.String>, System.Action, System.Action, System.Action<System.Object>[])

BulkUpdate(ITableData, ICollection<String>, ICollection<String>)

Performs a bulk update

Declaration
public override void BulkUpdate(ITableData data, ICollection<string> setColumnNames, ICollection<string> joinColumnNames)
Parameters
Type Name Description
ITableData data

Batch of data

System.Collections.Generic.ICollection<System.String> setColumnNames
System.Collections.Generic.ICollection<System.String> joinColumnNames
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.BulkUpdate(ETLBox.ControlFlow.ITableData, System.Collections.Generic.ICollection<System.String>, System.Collections.Generic.ICollection<System.String>)

CleanUpBulkInsert(String)

Called after the whole bulk insert operation to change back settings made to improve bulk insert performance

Declaration
public override void CleanUpBulkInsert(string tablename)
Parameters
Type Name Description
System.String tablename
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.CleanUpBulkInsert(System.String)

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
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.Clone()

OverrideConnectionSpecifics(ConnectionManagerType, String, String, String)

Changes the connection manager type for the generic connector, so that you can try to use it with not supported setups. If you are looking for supported Odbc connection managers, try to use the specific connection managers (e.g. MySqlOdbcConnectionManager for MySql or PostgresOdbcConnectionManager for Postgres)

Declaration
public void OverrideConnectionSpecifics(ConnectionManagerType connectionManagerType, string QB, string QE, string PP = "@")
Parameters
Type Name Description
ConnectionManagerType connectionManagerType

The new connection type for this connection manager.

System.String QB

Quotation begin (e.g. "`" for MySql or "[" for SqlServer)

System.String QE

Quotation end (e.g. "`" for MySql or "]" for SqlServer)

System.String PP

Parameter placeholder ("@" for most databases)

PrepareBulkInsert(String)

Performs preparations needed to improved performance of a bulk insert operation

Declaration
public override void PrepareBulkInsert(string tablename)
Parameters
Type Name Description
System.String tablename
Overrides
ETLBox.Connection.DbConnectionManager<System.Data.Odbc.OdbcConnection, System.Data.Odbc.OdbcTransaction, System.Data.Odbc.OdbcParameter>.PrepareBulkInsert(System.String)

Implements

IConnectionManager<TConnection, TTransaction>
IConnectionManager
System.IDisposable
In This Article
Back to top Crafted with <3 in Berlin
Contact & legal notice