Class MsSqlCRUDTransaction
Represents MsSQL CRUD transaction
Inheritance
System.Object
MsSqlCRUDTransaction
Implements
System.IDisposable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Assembly: Azos.MsSql.dll
Syntax
public sealed class MsSqlCRUDTransaction : CRUDTransaction, IDisposable, ICRUDOperations
Properties
Connection
Returns the underlying MySQL connection that this transaction works through
Declaration
public SqlConnection Connection { get; }
Property Value
| Type |
Description |
| System.Data.SqlClient.SqlConnection |
|
Transaction
Returns the underlying MySQL transaction that this instance represents. Do not call Commit/Rollback method on this property directly
Declaration
public SqlTransaction Transaction { get; }
Property Value
| Type |
Description |
| System.Data.SqlClient.SqlTransaction |
|
Methods
Destructor()
Declaration
protected override void Destructor()
Overrides
DoCommit()
Declaration
protected override void DoCommit()
Overrides
DoDelete(Doc, IDataStoreKey)
Declaration
protected override int DoDelete(Doc doc, IDataStoreKey key)
Parameters
Returns
| Type |
Description |
| System.Int32 |
|
Overrides
DoDeleteAsync(Doc, IDataStoreKey)
Declaration
protected override Task<int> DoDeleteAsync(Doc doc, IDataStoreKey key)
Parameters
Returns
| Type |
Description |
| System.Threading.Tasks.Task<System.Int32> |
|
Overrides
DoExecuteWithoutFetch(Query[])
Declaration
protected override int DoExecuteWithoutFetch(params Query[] queries)
Parameters
| Type |
Name |
Description |
| Query[] |
queries |
|
Returns
| Type |
Description |
| System.Int32 |
|
Overrides
DoExecuteWithoutFetchAsync(Query[])
Declaration
protected override Task<int> DoExecuteWithoutFetchAsync(params Query[] queries)
Parameters
| Type |
Name |
Description |
| Query[] |
queries |
|
Returns
| Type |
Description |
| System.Threading.Tasks.Task<System.Int32> |
|
Overrides
DoGetSchema(Query)
Declaration
protected override Schema DoGetSchema(Query query)
Parameters
| Type |
Name |
Description |
| Query |
query |
|
Returns
Overrides
DoGetSchemaAsync(Query)
Declaration
protected override Task<Schema> DoGetSchemaAsync(Query query)
Parameters
| Type |
Name |
Description |
| Query |
query |
|
Returns
| Type |
Description |
| System.Threading.Tasks.Task<Schema> |
|
Overrides
DoInsert(Doc, FieldFilterFunc)
Declaration
protected override int DoInsert(Doc doc, FieldFilterFunc filter = null)
Parameters
Returns
| Type |
Description |
| System.Int32 |
|
Overrides
DoInsertAsync(Doc, FieldFilterFunc)
Declaration
protected override Task<int> DoInsertAsync(Doc doc, FieldFilterFunc filter = null)
Parameters
Returns
| Type |
Description |
| System.Threading.Tasks.Task<System.Int32> |
|
Overrides
DoLoad(Boolean, Query[])
Declaration
protected override List<RowsetBase> DoLoad(bool oneDoc, params Query[] queries)
Parameters
| Type |
Name |
Description |
| System.Boolean |
oneDoc |
|
| Query[] |
queries |
|
Returns
| Type |
Description |
| System.Collections.Generic.List<RowsetBase> |
|
Overrides
DoLoadAsync(Boolean, Query[])
Declaration
protected override Task<List<RowsetBase>> DoLoadAsync(bool oneDoc, params Query[] queries)
Parameters
| Type |
Name |
Description |
| System.Boolean |
oneDoc |
|
| Query[] |
queries |
|
Returns
| Type |
Description |
| System.Threading.Tasks.Task<System.Collections.Generic.List<RowsetBase>> |
|
Overrides
DoOpenCursor(Query)
Declaration
protected override Cursor DoOpenCursor(Query query)
Parameters
| Type |
Name |
Description |
| Query |
query |
|
Returns
Overrides
DoOpenCursorAsync(Query)
Declaration
protected override Task<Cursor> DoOpenCursorAsync(Query query)
Parameters
| Type |
Name |
Description |
| Query |
query |
|
Returns
| Type |
Description |
| System.Threading.Tasks.Task<Cursor> |
|
Overrides
DoRollback()
Declaration
protected override void DoRollback()
Overrides
DoSave(RowsetBase[])
Declaration
protected override int DoSave(params RowsetBase[] rowsets)
Parameters
Returns
| Type |
Description |
| System.Int32 |
|
Overrides
DoSaveAsync(RowsetBase[])
Declaration
protected override Task<int> DoSaveAsync(params RowsetBase[] rowsets)
Parameters
Returns
| Type |
Description |
| System.Threading.Tasks.Task<System.Int32> |
|
Overrides
DoUpdate(Doc, IDataStoreKey, FieldFilterFunc)
Declaration
protected override int DoUpdate(Doc doc, IDataStoreKey key, FieldFilterFunc filter = null)
Parameters
Returns
| Type |
Description |
| System.Int32 |
|
Overrides
DoUpdateAsync(Doc, IDataStoreKey, FieldFilterFunc)
Declaration
protected override Task<int> DoUpdateAsync(Doc doc, IDataStoreKey key, FieldFilterFunc filter = null)
Parameters
Returns
| Type |
Description |
| System.Threading.Tasks.Task<System.Int32> |
|
Overrides
DoUpsert(Doc, FieldFilterFunc)
Declaration
protected override int DoUpsert(Doc doc, FieldFilterFunc filter = null)
Parameters
Returns
| Type |
Description |
| System.Int32 |
|
Overrides
DoUpsertAsync(Doc, FieldFilterFunc)
Declaration
protected override Task<int> DoUpsertAsync(Doc doc, FieldFilterFunc filter = null)
Parameters
Returns
| Type |
Description |
| System.Threading.Tasks.Task<System.Int32> |
|
Overrides
Implements
System.IDisposable
Extension Methods