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
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
| 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
ConnectionType
The database type for the connection manager.
Declaration
public override ConnectionType ConnectionType { get; protected set; }
Property Value
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| 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
| Type | Description |
|---|---|
| bool |
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, 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.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.BulkDelete(ETLBox.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.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
| Type | Name | Description |
|---|---|---|
| ITableData | data | |
| ICollection<><string> | selectColumnNames | |
| Action | beforeRowReadAction | |
| Action | afterRowReadAction | |
| Action<><object>[] | rowActions |
BulkUpdate(ITableData, ICollection<string>, ICollection<string>)
Declaration
public override void BulkUpdate(ITableData data, ICollection<string> setColumnNames, ICollection<string> joinColumnNames)
Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | |
| 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
| Type | Name | Description |
|---|---|---|
| string | tablename |
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, 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.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
| Type | Name | Description |
|---|---|---|
| string | tablename |
Overrides
ETLBox.DbConnectionManager<OracleConnection, OracleTransaction, OracleParameter>.PrepareBulkInsert(string)
Implements
System.IDisposable