SqlTransaction Class
Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.
Assembly: System.Data (in System.Data.dll)
System::MarshalByRefObject
System.Data.Common::DbTransaction
System.Data.SqlClient::SqlTransaction
| Name | Description | |
|---|---|---|
![]() | Connection | Gets the SqlConnection object associated with the transaction, or null if the transaction is no longer valid. |
![]() | IsolationLevel | Specifies the IsolationLevel for this transaction.(Overrides DbTransaction::IsolationLevel.) |
| Name | Description | |
|---|---|---|
![]() | Commit() | Commits the database transaction.(Overrides DbTransaction::Commit().) |
![]() | CreateObjRef(Type^) | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.(Inherited from MarshalByRefObject.) |
![]() | Dispose() | Releases the unmanaged resources used by the DbTransaction.(Inherited from DbTransaction.) |
![]() | Equals(Object^) | Determines whether the specified object is equal to the current object.(Inherited from Object.) |
![]() | GetHashCode() | Serves as the default hash function. (Inherited from Object.) |
![]() | GetLifetimeService() | Retrieves the current lifetime service object that controls the lifetime policy for this instance.(Inherited from MarshalByRefObject.) |
![]() | GetType() | |
![]() | InitializeLifetimeService() | Obtains a lifetime service object to control the lifetime policy for this instance.(Inherited from MarshalByRefObject.) |
![]() | Rollback() | Rolls back a transaction from a pending state.(Overrides DbTransaction::Rollback().) |
![]() | Rollback(String^) | Rolls back a transaction from a pending state, and specifies the transaction or savepoint name. |
![]() | Save(String^) | Creates a savepoint in the transaction that can be used to roll back a part of the transaction, and specifies the savepoint name. |
![]() | ToString() | Returns a string that represents the current object.(Inherited from Object.) |
| Name | Description | |
|---|---|---|
![]() ![]() | IDbTransaction::Connection | Gets the DbConnection object associated with the transaction, or a null reference if the transaction is no longer valid.(Inherited from DbTransaction.) |
The application creates a SqlTransaction object by calling BeginTransaction on the SqlConnection object. All subsequent operations associated with the transaction (for example, committing or aborting the transaction), are performed on the SqlTransaction object.
Note |
|---|
Try/Catch exception handling should always be used when committing or rolling back a SqlTransaction. Both Commit and Rollback generate an InvalidOperationException if the connection is terminated or if the transaction has already been rolled back on the server. |
For more information on SQL Server transactions, see Explicit Transactions and Coding Efficient Transactions.
The following example creates a SqlConnection and a SqlTransaction. It also demonstrates how to use the BeginTransaction, Commit, and Rollback methods. The transaction is rolled back on any error, or if it is disposed without first being committed. Try/Catch error handling is used to handle any errors when attempting to commit or roll back the transaction.
Available since 1.1
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.




