Class OracleConnectionManager

Connection manager of an ETLBox connection to an Oracle database. Usess the official Oracle ADO.NET driver for .NET core.

Inheritance
object
DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>
OracleConnectionManager
Implements
IConnectionManager<OracleConnection, OracleTransaction>
System.IDisposable
Inherited Members
Namespace: ETLBox.Oracle
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
TypeNameDescription
OracleConnectionStringconnectionString
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
TypeNameDescription
stringconnectionString
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

ConnectionType

The database type for the connection manager.

Declaration
    public override ConnectionType ConnectionType { get; protected set; }
Property Value
TypeDescription
ConnectionType
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.ConnectionType

MaxParameterSizeBulkCopy

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

Declaration
    public override int MaxParameterSizeBulkCopy { get; set; }
Property Value
TypeDescription
int
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.MaxParameterSizeBulkCopy

MaxParameterSizeSql

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

Declaration
    public override int MaxParameterSizeSql { get; set; }
Property Value
TypeDescription
int
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.MaxParameterSizeSql

PP

The character that is used in front of parameter names in query to identify the parameter. Most databases use the '@' character, some use ':'.

Declaration
    public override string PP { get; protected set; }
Property Value
TypeDescription
string
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, 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
TypeDescription
string
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, 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
TypeDescription
string
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, 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
TypeDescription
bool
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, 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
TypeDescription
bool
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.SupportSchemas

Methods

BulkDelete(ITableData)

Performs a bulk delete

Declaration
    public override void BulkDelete(ITableData data)
Parameters
TypeNameDescription
ITableDatadata

Batch of data

Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.BulkDelete(ETLBox.ITableData)

BulkInsert(ITableData)

Performs a bulk insert

Declaration
    public override void BulkInsert(ITableData data)
Parameters
TypeNameDescription
ITableDatadata

Batch of data

Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.BulkInsert(ETLBox.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
TypeNameDescription
ITableDatadata
ICollection<><string>selectColumnNames
ActionbeforeRowReadAction
ActionafterRowReadAction
Action<><object>[]rowActions

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

Declaration
    public override void BulkUpdate(ITableData data, ICollection<string> setColumnNames, ICollection<string> joinColumnNames)
Parameters
TypeNameDescription
ITableDatadata
ICollection<><string>setColumnNames
ICollection<><string>joinColumnNames

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
TypeNameDescription
stringtablename
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.CleanUpBulkInsert(string)

Clone()

Cretes a clone of the current connection manager

Declaration
    public override IConnectionManager Clone()
Returns
TypeDescription
IConnectionManager

A instance copy of the current connection manager

Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.Clone()

PrepareBulkInsert(string)

Performs preparations needed to improved performance of a bulk insert operation

Declaration
    public override void PrepareBulkInsert(string tablename)
Parameters
TypeNameDescription
stringtablename
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.PrepareBulkInsert(string)

Implements

System.IDisposable