SqlTransaction

E277026

SqlTransaction is a .NET class that represents a SQL Server database transaction, allowing you to commit or roll back a series of operations as a single unit of work.

All labels observed (2)

How this entity was disambiguated

Statements (49)

Predicate Object
instanceOf .NET class
ADO.NET class
database transaction abstraction
associatedWith SqlCommand
DbConnection
surface form: SqlConnection
belongsToAssembly System.Data
surface form: System.Data.dll
canBeAssignedTo SqlCommand.Transaction property
createdBy SqlConnection.BeginTransaction()
SqlTransaction self-linksurface differs
surface form: SqlConnection.BeginTransaction(IsolationLevel)
definedIn System.Data
surface form: System.Data.SqlClient namespace
documentationUrl https://learn.microsoft.com/dotnet/api/system.data.sqlclient.sqltransaction
ensuresProperty all-or-nothing execution of a set of SQL statements
hasMethod Commit()
Dispose()
Equals(Object)
GetHashCode()
GetType()
Rollback()
Rollback(String)
Save(String)
ToString()
hasProperty Connection
IsolationLevel
SupportsSavepoints
TransactionId
implements System.IDisposable
surface form: IDisposable
inheritsFrom DbTransaction
introducedIn .NET Framework
surface form: .NET Framework 1.1
languageBinding C# programming language
surface form: C#

Visual Basic .NET
surface form: VB.NET
lifecycle valid until committed, rolled back, or connection is closed
partOf ADO.NET
platform .NET 5
surface form: .NET 5+

.NET Core
.NET Framework
represents SQL Server database transaction
requires open SqlConnection
rollbackOn unhandled exceptions when explicitly rolled back by code
supportsFeature savepoints via Save(String)
supportsOperation Commit
Dispose
Rollback
Save
threadSafety instance members are not guaranteed to be thread-safe
usedFor controlling transaction isolation level
ensuring atomicity of database operations
explicit transaction management in ADO.NET
grouping multiple SQL commands into a single unit of work
usedWith SQL Server

How these facts were elicited

Referenced by (3)

Full triples — surface form annotated when it differs from this entity's canonical label.

SqlTransaction createdBy SqlTransaction self-linksurface differs
this entity surface form: SqlConnection.BeginTransaction(IsolationLevel)
SqlBulkCopy canUseTransaction SqlTransaction