Class BatchSave
The BatchSave Class.
Inherited Members
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public sealed class BatchSave : SqlCommand, IEnumerable<PrivateSave>, IEnumerable, ICloneableConstructors
BatchSave()
Initializes a new instance of the BatchSave class. Transaction logging will be controlled by each individual command.
Declaration
public BatchSave()BatchSave(BatchSave.TravelTransactionLogging)
Initializes a new instance of the BatchSave class, setting a default policy for travel transaction logging
Declaration
public BatchSave(BatchSave.TravelTransactionLogging howToLog)Parameters
| Type | Name | Description |
|---|---|---|
| BatchSave.TravelTransactionLogging | howToLog |
BatchSave(PrivateSave[])
Constructor that takes one or more queries as arguments, and adds them to the batch
Declaration
public BatchSave(params PrivateSave[] commands)Parameters
| Type | Name | Description |
|---|---|---|
| PrivateSave[] | commands | One or more PrivateSave queries to be added |
Properties
Count
Get count of elements in BatchSave list
Declaration
public int Count { get; }Property Value
| Type | Description |
|---|---|
| Int32 |
OverrideTransactionLogging
Declaration
public BatchSave.TravelTransactionLogging OverrideTransactionLogging { get; set; }Property Value
| Type | Description |
|---|---|
| BatchSave.TravelTransactionLogging |
SqlType
Get SqlType
Declaration
public override SqlType SqlType { get; }Property Value
| Type | Description |
|---|---|
| SqlType |
Overrides
Methods
Add(PrivateSave[])
Add one or more PrivateSave command
Declaration
public void Add(params PrivateSave[] commands)Parameters
| Type | Name | Description |
|---|---|---|
| PrivateSave[] | commands |
AddRange(IEnumerable<PrivateSave>)
Add a range of commands
Declaration
public void AddRange(IEnumerable<PrivateSave> commands)Parameters
| Type | Name | Description |
|---|---|---|
| IEnumerable<PrivateSave> | commands | Range (enumeration) of commands to add |
Clear()
Declaration
public void Clear()Clone()
Return deep copy of the Batch Save
Declaration
public object Clone()Returns
| Type | Description |
|---|---|
| Object | Copy of all the contained saves; SqlType.IsNoType items (typically Rows with no save required) are skipped |
GetTableInfos()
Obtain a list of all tables involved in the query.
Declaration
public override TableInfo[] GetTableInfos()Returns
| Type | Description |
|---|---|
| TableInfo[] | List of all tables involved in the query. |
Overrides
ToString()
String output.
Declaration
public override string ToString()Returns
| Type | Description |
|---|---|
| String | BEGIN TRANS .... COMMIT |
Overrides
Explicit Interface Implementations
IEnumerable<PrivateSave>.GetEnumerator()
Returns an enumerator that iterates through the collection.
Declaration
IEnumerator<PrivateSave> IEnumerable<PrivateSave>.GetEnumerator()Returns
| Type | Description |
|---|---|
| IEnumerator<PrivateSave> | A IEnumerator<T> that can be used to iterate through the collection. |
IEnumerable.GetEnumerator()
Returns an enumerator that iterates through a collection.
Declaration
IEnumerator IEnumerable.GetEnumerator()Returns
| Type | Description |
|---|---|
| IEnumerator | An IEnumerator object that can be used to iterate through the collection. |