C# Class Tiraggo.Interfaces.tgTransactionScope

This is the EntitySpaces ADO.NET connection based transaction class that mimics the System.Transactions.TransactionScope class.
EntitySpaces supports two transactions models, connection based via this class (tgTransactionScope) and the new System.Transactions.TransactionScope. Some databases such as Microsoft Access don't support the new System.Transactions.TransactionScope class. And still there are other cases where the System.Transactions.TransactionScope class cannot be used as is the case with a lot of hosting companies. Thus EntitySpaces provides a very nice ADO.NET connection based transaction handler. The Syntax should be as follows: using (tgTransactionScope scope = new tgTransactionScope()) { // Logic here ... scope.Complete(); // last line of using statement } Note that if an exception is thrown scope.Complete will not be called, and the transaction upon leaving the using statement will be rolled back. You indicate whether you want the provider to use the tgTransactionScope or the System.Transactions.TransactionScope class in your .config file. Notice in the config file setting below that providerClass="DataProvider". This indicates that you want to use the tgTransactionScope class, use providerClass="DataProviderEnterprise" to use System.Transactions.TransactionScope. <add name="SQL" providerMetadataKey="esDefault" sqlAccessType="DynamicSQL" provider="Tiraggo.SqlClientProvider" providerClass="DataProvider" connectionString="User ID=sa;Password=griffinski;Initial Catalog=Northwind;Data Source=localhost" databaseVersion="2005"/>
Inheritance: IDisposable
Datei anzeigen Open project: BrewDawg/Tiraggo Class Usage Examples

Public Methods

Method Description
AddForCommit ( ICommittable commit ) : bool

You should never call this directly, EntitySpaces calls this internally.

Complete ( ) : void

You must call Complete to commit the transaction. Calls and transactions can be nested, only the final outer call to Complete will commit the transaction.

DeEnlist ( IDbCommand cmd ) : void

You should never call this directly, the providers call this method.

Enlist ( IDbCommand cmd, string connectionString, CreateIDbConnectionDelegate creator ) : void

You should never call this directly, the providers call this method.

GetCurrentTransactionScopeOption ( ) : tgTransactionScopeOption

This can be used to get the tgTransactionScopeOption from the current tgTransactionScope (remember transactions can be nested). If there is no on-going transaction then tgTransactionScopeOption.None is returned.

tgTransactionScope ( ) : System

The default constructor, this transactions tgTransactionScopeOption will be set to Required. The IsolationLevel is set to Unspecified. using (tgTransactionScope scope = new tgTransactionScope()) { // Do your work here scope.Complete(); }

tgTransactionScope ( tgTransactionScopeOption option ) : System

Use this constructor to control the tgTransactionScopeOption as it applies to this transaction. using (tgTransactionScope scope = new tgTransactionScope(tgTransactionScopeOption.RequiresNew)) { // Do your work here scope.Complete(); }

tgTransactionScope ( tgTransactionScopeOption option, IsolationLevel level ) : System

Use this constructor to control the tgTransactionScopeOption as it applies to this transaction. using (tgTransactionScope scope = new tgTransactionScope(tgTransactionScopeOption.RequiresNew, IsolationLevel.ReadCommitted)) { // Do your work here scope.Complete(); }

Protected Methods

Method Description
CommonInit ( tgTransactionScope tx ) : void

This is the common constructor logic, tx is "this" from the constructor

Private Methods

Method Description
GetCurrentTx ( ) : tgTransactionScope

Internal method.

IDisposable ( ) : void

Internal. Called when the "using" statement is exited.

Rollback ( ) : void

Internal method, called if the "using" statement is left without calling scope.Complete()

Method Details

AddForCommit() public static method

You should never call this directly, EntitySpaces calls this internally.
public static AddForCommit ( ICommittable commit ) : bool
commit ICommittable Any class that implements ICommittable
return bool

CommonInit() protected static method

This is the common constructor logic, tx is "this" from the constructor
protected static CommonInit ( tgTransactionScope tx ) : void
tx tgTransactionScope
return void

Complete() public method

You must call Complete to commit the transaction. Calls and transactions can be nested, only the final outer call to Complete will commit the transaction.
public Complete ( ) : void
return void

DeEnlist() public static method

You should never call this directly, the providers call this method.
public static DeEnlist ( IDbCommand cmd ) : void
cmd IDbCommand The command to enlist into a transaction
return void

Enlist() public static method

You should never call this directly, the providers call this method.
public static Enlist ( IDbCommand cmd, string connectionString, CreateIDbConnectionDelegate creator ) : void
cmd IDbCommand The command to enlist into a transaction
connectionString string The connection string passed to the CreateIDbConnectionDelegate delegate
creator CreateIDbConnectionDelegate The delegate previously registered by the provider
return void

GetCurrentTransactionScopeOption() public static method

This can be used to get the tgTransactionScopeOption from the current tgTransactionScope (remember transactions can be nested). If there is no on-going transaction then tgTransactionScopeOption.None is returned.
public static GetCurrentTransactionScopeOption ( ) : tgTransactionScopeOption
return tgTransactionScopeOption

tgTransactionScope() public method

The default constructor, this transactions tgTransactionScopeOption will be set to Required. The IsolationLevel is set to Unspecified. using (tgTransactionScope scope = new tgTransactionScope()) { // Do your work here scope.Complete(); }
public tgTransactionScope ( ) : System
return System

tgTransactionScope() public method

Use this constructor to control the tgTransactionScopeOption as it applies to this transaction. using (tgTransactionScope scope = new tgTransactionScope(tgTransactionScopeOption.RequiresNew)) { // Do your work here scope.Complete(); }
public tgTransactionScope ( tgTransactionScopeOption option ) : System
option tgTransactionScopeOption See
return System

tgTransactionScope() public method

Use this constructor to control the tgTransactionScopeOption as it applies to this transaction. using (tgTransactionScope scope = new tgTransactionScope(tgTransactionScopeOption.RequiresNew, IsolationLevel.ReadCommitted)) { // Do your work here scope.Complete(); }
public tgTransactionScope ( tgTransactionScopeOption option, IsolationLevel level ) : System
option tgTransactionScopeOption See
level IsolationLevel See IsolationLevel in the System.Data namespace
return System