Class Db2ConnectionManager

{{< /rawhtml >}} ```C# public class Db2ConnectionManager : DbConnectionManager, IConnectionManager, IConnectionManager, IDisposable ``` {{< rawhtml >}}

Examples

var db2Connection = new Db2ConnectionManager("Data Source=.;");

Constructors

Db2ConnectionManager()

Declaration

{{< /rawhtml >}} ```C# public Db2ConnectionManager() ``` {{< rawhtml >}}

Db2ConnectionManager(Db2ConnectionString)

Declaration

{{< /rawhtml >}} ```C# public Db2ConnectionManager(Db2ConnectionString connectionString) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
Db2ConnectionString	connectionString

Db2ConnectionManager(string)

Declaration

{{< /rawhtml >}} ```C# public Db2ConnectionManager(string connectionString) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	connectionString

Properties

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<IBM.Data.DB2.Core.DB2Connection, IBM.Data.DB2.Core.DB2Transaction, IBM.Data.DB2.Core.DB2Parameter>.ConnectionType

MaxParameterSizeBulkCopy

Returns the maximum amount of parameters that can be used for bulk inserts.

Declaration

{{< /rawhtml >}} ```C# public override int MaxParameterSizeBulkCopy { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
int

Overrides

ETLBox.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection, IBM.Data.DB2.Core.DB2Transaction, IBM.Data.DB2.Core.DB2Parameter>.MaxParameterSizeBulkCopy

MaxParameterSizeSql

Returns the maximum amount of parameters that can be passed into a sql query.

Declaration

{{< /rawhtml >}} ```C# public override int MaxParameterSizeSql { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
int

Overrides

ETLBox.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection, IBM.Data.DB2.Core.DB2Transaction, IBM.Data.DB2.Core.DB2Parameter>.MaxParameterSizeSql

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<IBM.Data.DB2.Core.DB2Connection, IBM.Data.DB2.Core.DB2Transaction, IBM.Data.DB2.Core.DB2Parameter>.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<IBM.Data.DB2.Core.DB2Connection, IBM.Data.DB2.Core.DB2Transaction, IBM.Data.DB2.Core.DB2Parameter>.QE

SupportDatabases

Indicates if database server does support multiple databases. A database in ETLBox means a schema in MySql.

Declaration

{{< /rawhtml >}} ```C# public override bool SupportDatabases { get; protected set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

Overrides

ETLBox.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection, IBM.Data.DB2.Core.DB2Transaction, IBM.Data.DB2.Core.DB2Parameter>.SupportDatabases

SupportProcedures

Indicates if the database supports procedures

Declaration

{{< /rawhtml >}} ```C# public override bool SupportProcedures { get; protected set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

Overrides

ETLBox.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection, IBM.Data.DB2.Core.DB2Transaction, IBM.Data.DB2.Core.DB2Parameter>.SupportProcedures

UseSqlBulkOperations

By default bulk inserts are done using the DB2BulkCopy. This provides better performance, but it won't support Transactions and foreign key constraints. If you need support for transactions or constraints, set this flag to true.

Declaration

{{< /rawhtml >}} ```C# public bool UseSqlBulkOperations { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

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<IBM.Data.DB2.Core.DB2Connection, IBM.Data.DB2.Core.DB2Transaction, IBM.Data.DB2.Core.DB2Parameter>.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<IBM.Data.DB2.Core.DB2Connection, IBM.Data.DB2.Core.DB2Transaction, IBM.Data.DB2.Core.DB2Parameter>.BulkInsert(ETLBox.ITableData)

BulkSelect(ITableData, ICollection<string>, Action, Action, params Action<object>[])

Performs a bulk select

Declaration

{{< /rawhtml >}} ```C# public override void BulkSelect(ITableData data, ICollection selectColumnNames, Action beforeRowReadAction, Action afterRowReadAction, params Action

Type	Name	Description
ITableData	data	Batch of data needed for the where condition
ICollection<string>	selectColumnNames	Column names included in the select
Action	beforeRowReadAction	Action invoked before any data is read
Action	afterRowReadAction	Action invoked after all data is read
Action<object>[]	rowActions