Class OracleOperations

Database operations for Oracle

Inheritance
Object
DatabaseOperations
OracleOperations
Inherited Members
Namespace: SuperOffice.Data.Dialect
Assembly: SoDataBase.dll
Syntax
public class OracleOperations : DatabaseOperations

Methods

GetDatabaseSize()

Get the total database size (including any unallocated space inside the db, etc) in megabytes

Declaration
public override int GetDatabaseSize()
Returns
Type Description
Int32
Overrides

GetDatabaseVersion()

Database operations for Oracle

Declaration
public override string GetDatabaseVersion()
Returns
Type Description
String
Overrides

GetKilobytes(SoTable)

Database operations for Oracle

Declaration
public override int GetKilobytes(SoTable table)
Parameters
Type Name Description
SoTable table
Returns
Type Description
Int32
Overrides

GetRowCount(SoTable)

Database operations for Oracle

Declaration
public override int GetRowCount(SoTable table)
Parameters
Type Name Description
SoTable table
Returns
Type Description
Int32
Overrides

InnerTruncateTable(SoTable, DatabaseOperations.TruncateOptions)

Throw away all the rows in a table. On most databases this is an operation that is very fast, but it is not logged in the database transaction log and so cannot be rolled back.

It is also not logged in the superoffice traveltransactionlog, so it is not replicated, and should generally not be used on tables that are subject to replication.
Declaration
public override void InnerTruncateTable(SoTable table, DatabaseOperations.TruncateOptions options)
Parameters
Type Name Description
SoTable table
DatabaseOperations.TruncateOptions options
Overrides

WriteBulkRows(DatabaseOperations.BulkImportInfo)

Write rows using the underlying database implementation's bulk import functionality.

Declaration
protected override void WriteBulkRows(DatabaseOperations.BulkImportInfo importInfo)
Parameters
Type Name Description
DatabaseOperations.BulkImportInfo importInfo
Overrides
Remarks

Read more about the OracleBulkCopy class here: https://docs.oracle.com/en/database/oracle/oracle-database/19/odpnt/featBulkCopy.html

Extension Methods

EnumUtil.MapEnums<From, To>(From)