SqliteConnection.BeginTransaction Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| BeginTransaction() |
Begins a transaction on the connection. |
| BeginTransaction(Boolean) |
Begins a transaction on the connection. |
| BeginTransaction(IsolationLevel) |
Begins a transaction on the connection. |
| BeginTransaction(IsolationLevel, Boolean) |
Begins a transaction on the connection. |
BeginTransaction()
Begins a transaction on the connection.
public virtual Microsoft.Data.Sqlite.SqliteTransaction BeginTransaction ();override this.BeginTransaction : unit -> Microsoft.Data.Sqlite.SqliteTransactionPublic Overridable Function BeginTransaction () As SqliteTransactionReturns
The transaction.
Exceptions
A SQLite error occurs during execution.
Applies to
BeginTransaction(Boolean)
Begins a transaction on the connection.
public virtual Microsoft.Data.Sqlite.SqliteTransaction BeginTransaction (bool deferred);override this.BeginTransaction : bool -> Microsoft.Data.Sqlite.SqliteTransactionPublic Overridable Function BeginTransaction (deferred As Boolean) As SqliteTransactionParameters
- deferred
- Boolean
true to defer the creation of the transaction.
This also causes transactions to upgrade from read transactions to write transactions as needed by their commands.
Returns
The transaction.
Exceptions
A SQLite error occurs during execution.
Remarks
Warning, commands inside a deferred transaction can fail if they cause the transaction to be upgraded from a read transaction to a write transaction but the database is locked. The application will need to retry the entire transaction when this happens.
Applies to
BeginTransaction(IsolationLevel)
Begins a transaction on the connection.
public virtual Microsoft.Data.Sqlite.SqliteTransaction BeginTransaction (System.Data.IsolationLevel isolationLevel);override this.BeginTransaction : System.Data.IsolationLevel -> Microsoft.Data.Sqlite.SqliteTransactionPublic Overridable Function BeginTransaction (isolationLevel As IsolationLevel) As SqliteTransactionParameters
- isolationLevel
- IsolationLevel
The isolation level of the transaction.
Returns
The transaction.
Exceptions
A SQLite error occurs during execution.
Applies to
BeginTransaction(IsolationLevel, Boolean)
Begins a transaction on the connection.
public virtual Microsoft.Data.Sqlite.SqliteTransaction BeginTransaction (System.Data.IsolationLevel isolationLevel, bool deferred);override this.BeginTransaction : System.Data.IsolationLevel * bool -> Microsoft.Data.Sqlite.SqliteTransactionPublic Overridable Function BeginTransaction (isolationLevel As IsolationLevel, deferred As Boolean) As SqliteTransactionParameters
- isolationLevel
- IsolationLevel
The isolation level of the transaction.
- deferred
- Boolean
true to defer the creation of the transaction.
This also causes transactions to upgrade from read transactions to write transactions as needed by their commands.
Returns
The transaction.
Exceptions
A SQLite error occurs during execution.
Remarks
Warning, commands inside a deferred transaction can fail if they cause the transaction to be upgraded from a read transaction to a write transaction but the database is locked. The application will need to retry the entire transaction when this happens.
Applies to
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for