System.Data.SqlClient.SqlTransaction Class

Represents a tsql transaction to be made in a ssNoVersion database. This class cannot be inherited.

See Also: SqlTransaction Members

Syntax

public sealed class SqlTransaction : System.Data.Common.DbTransaction

Remarks

The application creates a System.Data.SqlClient.SqlTransaction object by calling SqlConnection.BeginTransaction on the System.Data.SqlClient.SqlConnection object. All subsequent operations associated with the transaction (for example, committing or aborting the transaction), are performed on the System.Data.SqlClient.SqlTransaction object.

Note:

Try/Catch exception handling should always be used when committing or rolling back a System.Data.SqlClient.SqlTransaction. Both SqlTransaction.Commit and SqlTransaction.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 ssNoVersion transactions, see tp://msdn.microsoft.com/library/ms175127(SQL.105) and tp://msdn.microsoft.com/library/ms187484(SQL.105).

Requirements

Namespace: System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.3300.0, 1.0.5000.0, 2.0.0.0