Class BatchSave

The BatchSave Class.

Inheritance
System.Object
SqlCommand
BatchSave
Implements
System.Collections.Generic.IEnumerable<PrivateSave>
System.Collections.IEnumerable
System.ICloneable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public sealed class BatchSave : SqlCommand, IEnumerable<PrivateSave>, IEnumerable, ICloneable

Constructors

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
System.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
System.Collections.Generic.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
System.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
System.String

BEGIN TRANS .... COMMIT
Overrides
System.Object.ToString()

Explicit Interface Implementations

IEnumerable<PrivateSave>.GetEnumerator()

Returns an enumerator that iterates through the collection.

Declaration
IEnumerator<PrivateSave> IEnumerable<PrivateSave>.GetEnumerator()
Returns
Type Description
System.Collections.Generic.IEnumerator<PrivateSave>

A System.Collections.Generic.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
System.Collections.IEnumerator

An System.Collections.IEnumerator object that can be used to iterate through the collection.

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable
System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
IEnumerableExtensions.ForEach<T>(System.Collections.Generic.IEnumerable<T>, System.Action<T>)
IEnumerableExtensions.ContainsAny<T>(System.Collections.Generic.IEnumerable<T>, System.Collections.Generic.IEnumerable<T>)
IEnumerableExtensions.Batch<T>(System.Collections.Generic.IEnumerable<T>, System.Int32)
IEnumerableExtensions.IndexOf<T>(System.Collections.Generic.IEnumerable<T>, T, System.Int32)
IEnumerableExtensions.IndexOf<T>(System.Collections.Generic.IEnumerable<T>, System.Func<T, System.Boolean>, System.Int32)
IEnumerableExtensions.Permute<T>(System.Collections.Generic.IEnumerable<T>, System.Int32)
IEnumerableExtensions.PermissiveToDictionary<T, K, V>(System.Collections.Generic.IEnumerable<T>, System.Func<T, K>, System.Func<T, V>)
IEnumerableExtensions.PermissiveToDictionary<T, K, V>(System.Collections.Generic.IEnumerable<T>, System.Func<T, K>, System.Func<T, V>, System.Collections.Generic.IEqualityComparer<K>)
IEnumerableExtensions.GetDifferentCombinations<T>(System.Collections.Generic.IEnumerable<T>, System.Int32)