SqliteTransaction Class

  • Reference

Definition

Namespace:
Microsoft.Data.Sqlite
Assembly:
Microsoft.Data.Sqlite.dll
Package:
Microsoft.Data.Sqlite v1.0.1
Package:
Microsoft.Data.Sqlite v1.1.1
Package:
Microsoft.Data.Sqlite.Core v2.0.1
Package:
Microsoft.Data.Sqlite.Core v2.1.11
Package:
Microsoft.Data.Sqlite.Core v2.2.6
Package:
Microsoft.Data.Sqlite.Core v3.0.0
Package:
Microsoft.Data.Sqlite.Core v3.1.0
Package:
Microsoft.Data.Sqlite.Core v5.0.0
Package:
Microsoft.Data.Sqlite.Core v6.0.0
Package:
Microsoft.Data.Sqlite.Core v7.0.0
Package:
Microsoft.Data.Sqlite.Core v8.0.0

Represents a transaction made against a SQLite database.

public class SqliteTransaction : System.Data.Common.DbTransaction
type SqliteTransaction = class
    inherit DbTransaction
Public Class SqliteTransaction
Inherits DbTransaction
Inheritance
DbTransaction
SqliteTransaction

Properties

Connection

Gets the connection associated with the transaction.
DbConnection

Gets the connection associated with the transaction.
IsolationLevel

Gets the isolation level for the transaction.
SupportsSavepoints

Gets a value that indicates whether this DbTransaction instance supports database savepoints. If false, the methods SaveAsync(String, CancellationToken), RollbackAsync(String, CancellationToken) and ReleaseAsync(String, CancellationToken) as well as their synchronous counterparts are expected to throw NotSupportedException.

Methods

Commit()

Applies the changes made in the transaction.
Dispose(Boolean)

Releases any resources used by the transaction and rolls it back.
Release(String)

Destroys a savepoint previously defined in the current transaction. This allows the system to reclaim some resources before the transaction ends.
Rollback()

Reverts the changes made in the transaction.
Rollback(String)

Rolls back all commands that were executed after the specified savepoint was established.
Save(String)

Creates a savepoint in the transaction. This allows all commands that are executed after the savepoint was established to be rolled back, restoring the transaction state to what it was at the time of the savepoint.

Applies to