• 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 SqlOleDbConnectionManager

Sql Server Connection manager for an OleDb connection to Sql Server.

Inheritance
System.Object
DbConnectionManager<System.Data.OleDb.OleDbConnection>
OleDbConnectionManager
SqlOleDbConnectionManager
Implements
IConnectionManager
System.IDisposable
Inherited Members
OleDbConnectionManager.IsOdbcOrOleDbConnection
OleDbConnectionManager.OleDbBulkInsert(BulkSqlGenerator<OleDbParameter>)
OleDbConnectionManager.BulkInsert(ITableData)
OleDbConnectionManager.BeforeBulkInsert(String)
OleDbConnectionManager.AfterBulkInsert(String)
OleDbConnectionManager.PrepareBulkInsert(String)
OleDbConnectionManager.CleanUpBulkInsert(String)
OleDbConnectionManager.BulkDelete(ITableData)
OleDbConnectionManager.BulkUpdate(ITableData, ICollection<String>, ICollection<String>)
OleDbConnectionManager.BulkSelect(ITableData, ICollection<String>, Action, Action, Action<Object>[])
DbConnectionManager<OleDbConnection>.DbConnection
DbConnectionManager<OleDbConnection>.MaxLoginAttempts
DbConnectionManager<OleDbConnection>.LeaveOpen
DbConnectionManager<OleDbConnection>.ConnectionString
DbConnectionManager<OleDbConnection>.State
DbConnectionManager<OleDbConnection>.Transaction
DbConnectionManager<OleDbConnection>.IsInBulkInsert
DbConnectionManager<OleDbConnection>.PP
DbConnectionManager<OleDbConnection>.SupportDatabases
DbConnectionManager<OleDbConnection>.SupportProcedures
DbConnectionManager<OleDbConnection>.SupportSchemas
DbConnectionManager<OleDbConnection>.SupportComputedColumns
DbConnectionManager<OleDbConnection>.DoPrepareCommand
DbConnectionManager<OleDbConnection>.MaxParameterAmount
DbConnectionManager<OleDbConnection>.ReadTableDefinition(ObjectNameDescriptor)
DbConnectionManager<OleDbConnection>.CheckIfTableOrViewExists(String)
DbConnectionManager<OleDbConnection>.CreateCommand(String, IEnumerable<QueryParameter>)
DbConnectionManager<OleDbConnection>.ExecuteNonQuery(String, IEnumerable<QueryParameter>)
DbConnectionManager<OleDbConnection>.ExecuteScalar(String, IEnumerable<QueryParameter>)
DbConnectionManager<OleDbConnection>.ExecuteReader(String, IEnumerable<QueryParameter>)
DbConnectionManager<OleDbConnection>.BeginTransaction(IsolationLevel)
DbConnectionManager<OleDbConnection>.BeginTransaction()
DbConnectionManager<OleDbConnection>.CommitTransaction()
DbConnectionManager<OleDbConnection>.RollbackTransaction()
DbConnectionManager<OleDbConnection>.CloneIfAllowed()
DbConnectionManager<OleDbConnection>.Open()
DbConnectionManager<OleDbConnection>.CreateDbConnection()
DbConnectionManager<OleDbConnection>.Close()
DbConnectionManager<OleDbConnection>.CloseIfAllowed()
DbConnectionManager<OleDbConnection>.Dispose(Boolean)
DbConnectionManager<OleDbConnection>.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.OleDb.dll
Syntax
public class SqlOleDbConnectionManager : OleDbConnectionManager, IConnectionManager, IDisposable

Constructors

SqlOleDbConnectionManager()

Declaration
public SqlOleDbConnectionManager()

SqlOleDbConnectionManager(OleDbConnectionString)

Declaration
public SqlOleDbConnectionManager(OleDbConnectionString connectionString)
Parameters
Type Name Description
OleDbConnectionString connectionString

SqlOleDbConnectionManager(String)

Declaration
public SqlOleDbConnectionManager(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
OleDbConnectionManager.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
OleDbConnectionManager.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
OleDbConnectionManager.QE

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
OleDbConnectionManager.Clone()

Implements

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