Class OracleMassOperations

Inheritance
object
MassOperations
OracleMassOperations
Implements
Inherited Members
Namespace: SuperOffice.Data.Dialect
Assembly: SoDataBase.BusinessLogic.dll
Syntax
public class OracleMassOperations : MassOperations, IMassOperations

Constructors

OracleMassOperations()

Declaration
public OracleMassOperations()

Methods

GetUpdateTargetFromTempSql(SoTable, SoTable, SoField, SoField, SoField, IEnumerable<string>)

Declaration
protected override string GetUpdateTargetFromTempSql(SoTable tempTable, SoTable targetTable, SoField tempId, SoField targetId, SoField tempStatus, IEnumerable<string> valueFields)
Parameters
Type Name Description
SoTable tempTable
SoTable targetTable
SoField tempId
SoField targetId
SoField tempStatus
IEnumerable<string> valueFields
Returns
Type Description
string
Overrides

GetUpdateTempTableWithDataMatchSql(SoTable, SoTable, SoField, SoField, SoField, IEnumerable<string>)

Declaration
protected override string GetUpdateTempTableWithDataMatchSql(SoTable tempTable, SoTable targetTable, SoField tempId, SoField targetId, SoField tempStatus, IEnumerable<string> valueFields)
Parameters
Type Name Description
SoTable tempTable
SoTable targetTable
SoField tempId
SoField targetId
SoField tempStatus
IEnumerable<string> valueFields
Returns
Type Description
string
Overrides

GetUpdateTempTableWithKeyMatchSql(SoTable, SoTable, SoField, SoField, SoField, IEnumerable<string>)

Declaration
protected override string GetUpdateTempTableWithKeyMatchSql(SoTable tempTable, SoTable targetTable, SoField tempId, SoField targetId, SoField tempStatus, IEnumerable<string> keys)
Parameters
Type Name Description
SoTable tempTable
SoTable targetTable
SoField tempId
SoField targetId
SoField tempStatus
IEnumerable<string> keys
Returns
Type Description
string
Overrides

GetUpdateTempTableWithNewKeysSql(SoTable, SoTable, SoField, SoField, SoField, IEnumerable<string>)

Declaration
protected override string GetUpdateTempTableWithNewKeysSql(SoTable tempTable, SoTable targetTable, SoField tempId, SoField targetId, SoField tempStatus, IEnumerable<string> keys)
Parameters
Type Name Description
SoTable tempTable
SoTable targetTable
SoField tempId
SoField targetId
SoField tempStatus
IEnumerable<string> keys
Returns
Type Description
string
Overrides

GetZeroOutColumnsSql(SoTable, SoTable, SoField, SoField, SoField[])

Declaration
protected override string GetZeroOutColumnsSql(SoTable tempTable, SoTable targetTable, SoField tempId, SoField targetId, SoField[] valueFieldDefs)
Parameters
Type Name Description
SoTable tempTable
SoTable targetTable
SoField tempId
SoField targetId
SoField[] valueFieldDefs
Returns
Type Description
string
Overrides

UpsertAsync(string, string[], string[], string[][], UpsertNomatchAction, bool, CancellationToken)

Insert or update rows. See parameters for further documentaiton.

Declaration
public override Task<MassResult> UpsertAsync(string tableName, string[] columns, string[] keys, string[][] data, UpsertNomatchAction nomatchAction, bool returnRowStatus, CancellationToken cancellationToken = default)
Parameters
Type Name Description
string tableName
string[] columns

List of column names, in the same order as in the data; both key and data columns must be in this list
string[] keys

List of columns that are to be used as keys, to match any existing rows
string[][] data

Outer array = row, inner = column in specified order; use Encode(object) to format non-string values
UpsertNomatchAction nomatchAction
bool returnRowStatus
CancellationToken cancellationToken
Returns
Type Description
Task<MassResult>

Summary of results
Overrides

Implements

Extension Methods