Class OracleConnectionManager
Connection manager of an ETLBox connection to an Oracle database. Usess the official Oracle ADO.NET driver for .NET core.
Inheritance
object
OracleConnectionManager
Implements
System.IDisposable
Inherited Members
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: ETLBox.Connection
Assembly: ETLBox.Oracle.dll
Syntax
public class OracleConnectionManager : DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>, IConnectionManager<OracleConnection, OracleTransaction>, IConnectionManager, IDisposable
Examples
var oracleConnection = new OracleConnectionManager("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=ORCLCDB)));User ID=etlbox;Password=password;");Constructors
OracleConnectionManager()
Declaration
public OracleConnectionManager()
Examples
var oracleConnection = new OracleConnectionManager("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=ORCLCDB)));User ID=etlbox;Password=password;");OracleConnectionManager(OracleConnectionString)
Declaration
public OracleConnectionManager(OracleConnectionString connectionString)
Parameters
| Type | Name | Description |
|---|---|---|
| OracleConnectionString | connectionString |
Examples
var oracleConnection = new OracleConnectionManager("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=ORCLCDB)));User ID=etlbox;Password=password;");OracleConnectionManager(string)
Declaration
public OracleConnectionManager(string connectionString)
Parameters
| Type | Name | Description |
|---|---|---|
| string | connectionString |
Examples
var oracleConnection = new OracleConnectionManager("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=ORCLCDB)));User ID=etlbox;Password=password;");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<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.ConnectionManagerType
MaxParameterSizeBulkCopy
Returns the maximum amount of parameters that can be used for bulk inserts.
Declaration
public override int MaxParameterSizeBulkCopy { get; protected set; }
Property Value
| Type | Description |
|---|---|
| int |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.MaxParameterSizeBulkCopy
MaxParameterSizeSql
Returns the maximum amount of parameters that can be passed into a sql query.
Declaration
public override int MaxParameterSizeSql { get; protected set; }
Property Value
| Type | Description |
|---|---|
| int |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.MaxParameterSizeSql
PP
The character that is used in front of parameter names in query to identify the parameter. All databases use the '@' character, except Oracle which uses ':'
Declaration
public override string PP { get; protected set; }
Property Value
| Type | Description |
|---|---|
| string |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.PP
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 |
|---|---|
| string |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.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 |
|---|---|
| string |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.QE
SupportDatabases
Indicates if database server does support multiple databases. A database in ETLBox means a schema in MySql.
Declaration
public override bool SupportDatabases { get; }
Property Value
| Type | Description |
|---|---|
| bool |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.SupportDatabases
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.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.SupportSchemas
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<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.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<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.BulkInsert(ETLBox.ControlFlow.ITableData)
BulkSelect(ITableData, ICollection<string>, Action, Action, params 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<T><string> | selectColumnNames | |
| System.Action | beforeRowReadAction | |
| System.Action | afterRowReadAction | |
| System.Action<T><object>[] | rowActions |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.BulkSelect(ETLBox.ControlFlow.ITableData, System.Collections.Generic.ICollection<string>, System.Action, System.Action, params System.Action<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<T><string> | setColumnNames | The column names used in the set part of the update statement |
| System.Collections.Generic.ICollection<T><string> | joinColumnNames | The column names to join for the update |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.BulkUpdate(ETLBox.ControlFlow.ITableData, System.Collections.Generic.ICollection<string>, System.Collections.Generic.ICollection<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 |
|---|---|---|
| string | tablename |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.CleanUpBulkInsert(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<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.Clone()
PrepareBulkInsert(string)
Performs preparations needed to improved performance of a bulk insert operation
Declaration
public override void PrepareBulkInsert(string tablename)
Parameters
| Type | Name | Description |
|---|---|---|
| string | tablename |
Overrides
ETLBox.Connection.DbConnectionManager<Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleTransaction, Oracle.ManagedDataAccess.Client.OracleParameter>.PrepareBulkInsert(string)
Implements
System.IDisposable