Show / Hide Table of Contents

Class BatchSave

The BatchSave Class.

Inheritance
Object
SqlCommand
BatchSave
Implements
IEnumerable<PrivateSave>
IEnumerable
ICloneable
Inherited Members
SqlCommand.Origin
SqlCommand.AddIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.AddIgnoreAutoSentryTableInfo(IEnumerable<TableInfo>)
SqlCommand.RemoveIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.ClearIgnoreAutoSentryTableInfos()
SqlCommand.IsAutoSentryIgnoredOnTableInfo(TableInfo)
SqlCommand.GetPrivateSaves()
SqlCommand.GetInserts()
SqlCommand.GetUpdates()
SqlCommand.GetDeletes()
SqlCommand.GetSelect()
SqlCommand.AutoSentryIgnoredTables
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
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
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
SqlCommand.SqlType

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
SqlCommand.GetTableInfos()

ToString()

String output.

Declaration
public override string ToString()
Returns
Type Description
String

BEGIN TRANS .... COMMIT

Overrides
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
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.

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)
CollectionOps.AtLeastOne<T>(IEnumerable<T>)
ObjectExtensions.AssignByReflection<T>(T, T)
ObjectExtensions.GraphCopy<T>(T)
QueryExectionExtensions.ExecuteReader(SqlCommand, Boolean)
QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)
QueryExectionExtensions.ExecuteNonQuery(SqlCommand)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top