Class MassOperations

Inheritance
Object
MassOperations
OracleMassOperations
SqlServerMassOperations
Namespace: SuperOffice.Data.Dialect
Assembly: SoDataBase.dll
Syntax
public abstract class MassOperations : Object

Constructors

MassOperations()

Declaration
protected MassOperations()

Methods

Delete(String, Int32[])

Delete rows, by primary key

Declaration
public virtual MassResult Delete(string tableName, int[] iDs)
Parameters
Type Name Description
String tableName
Int32[] iDs

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

Summary of results

GetCurrent()

Declaration
public static MassOperations GetCurrent()
Returns
Type Description
MassOperations

Insert(String, String[], String[][])

Mass-insert rows, with or without primary keys specified

Declaration
public virtual MassResult Insert(string tableName, string[] columns, string[][] data)
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
Returns
Type Description
MassResult

Summary of results

Truncate(String)

Drop all rows in a table

Declaration
public virtual MassResult Truncate(string tableName)
Parameters
Type Name Description
String tableName

Name of table to be truncated
Returns
Type Description
MassResult

Summary of results

Upsert(String, String[], String[], String[][], UpsertNomatchAction, Boolean)

Insert or update rows. See parameters for further documentaiton.

Declaration
public virtual MassResult Upsert(string tableName, string[] originalColumns, string[] originalKeys, string[][] data, UpsertNomatchAction nomatchAction, bool returnRowStatus = false)
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
Boolean returnRowStatus
Returns
Type Description
MassResult

Summary of results

Extension Methods

EnumUtil.MapEnums<From, To>(From)