Name

SqlTransaction

Synopsis

This class encapsulates a client-initiated database transaction. You can start a transaction, provided you have an open connection, by calling the SqlConnection.BeginTransaction( ) method, which returns a SqlTransaction object. The SqlTransaction class implements the System.Data.IDbTransaction interface, and its members are described in that section of the reference.

You can also use the Save( ) method to create a savepoint, which is similar to a nested transaction. (This method is equivalent to Transact-SQL SAVE TRANSACTION statement.) You must supply a string that names the savepoint. You can then roll back the transaction to an intermediate point using the overloaded version of the Rollback( ) method that accepts the savepoint name. Savepoints are useful when you want to be able to roll back part of the transaction without canceling the entire transaction.

public sealed class SqlTransaction : MarshalByRefObject, System.Data.IDbTransaction, IDisposable {

// Public Instance Properties

   public SqlConnection Connection{get; } 

   public IsolationLevel IsolationLevel{get; }                 // implements System.Data.IDbTransaction

                  // Public Instance Methods

   public void Commit( );                                       // implements System.Data.IDbTransaction

   public void Dispose( );                                      // implements IDisposable

   public void Rollback( );                                     // implements System.Data.IDbTransaction

   public void Rollback(string transactionName);  

   public void Save(string savePointName);  

}

Hierarchy

System.Object System.MarshalByRefObject SqlTransaction(System.Data.IDbTransaction ...

Get ADO.NET in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.