Class MassOperations

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

Constructors

MassOperations()

Declaration
protected MassOperations()

Methods

DeleteAsync(string, int[])

Delete rows, by primary key

Declaration
public virtual Task<MassResult> DeleteAsync(string tableName, int[] iDs)
Parameters
Type Name Description
string tableName
int[] iDs

Primary keys of the rows to be deleted
Returns
Type Description
Task<MassResult>

Summary of results

InsertAsync(string, string[], string[][], CancellationToken)

Mass-insert rows, with or without primary keys specified

Declaration
public virtual Task<MassResult> InsertAsync(string tableName, string[] columns, string[][] data, CancellationToken cancellationToken)
Parameters
Type Name Description
string tableName
string[] columns

List of column names, in the same order as in the data
string[][] data

Outer array = row, inner = column in specified order; use CultureDataFormatter to format values
CancellationToken cancellationToken
Returns
Type Description
Task<MassResult>

Summary of results

TruncateAsync(string, CancellationToken)

Drop all rows in a table

Declaration
public virtual Task<MassResult> TruncateAsync(string tableName, CancellationToken cancellationToken)
Parameters
Type Name Description
string tableName

Name of table to be truncated
CancellationToken cancellationToken
Returns
Type Description
Task<MassResult>

Summary of results

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

Insert or update rows. See parameters for further documentaiton.

Declaration
public virtual Task<MassResult> UpsertAsync(string tableName, string[] originalColumns, string[] originalKeys, string[][] data, UpsertNomatchAction nomatchAction, bool returnRowStatus = false, CancellationToken cancellationToken = default)
Parameters
Type Name Description
string tableName
string[] originalColumns
string[] originalKeys
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

Implements

Extension Methods