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(stringtransactionName
); public void Save(stringsavePointName
); }
Hierarchy
System.Object
→
System.MarshalByRefObject
→
SqlTransaction(System.Data.IDbTransaction ...
Get ADO.NET in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.