BeginTransaction(IsolationLevel) Method

In This Topic

Begins a database transaction with the specified isolation level.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shadows Function BeginTransaction( _
   ByVal isolationLevel As IsolationLevel _
) As SQLiteTransaction

public new SQLiteTransaction BeginTransaction( 
   IsolationLevel isolationLevel
)

Parameters

isolationLevel

Return Value

An object representing the new transaction.

Remarks

To commit or roll back the transaction, you must explicitly use the Commit or Rollback methods.

SQLite supports only Serializable isolation level.

Example

The following example creates a SQLiteConnection and a SQLiteTransaction. It also demonstrates how to use the BeginTransaction(), Commit, and Rollback methods.

csharp

public void RunSQLiteTransaction(string myConnString)
{
  SQLiteConnection sqConnection = new SQLiteConnection(myConnString);
  sqConnection.Open();

  SQLiteCommand sqCommand = new SQLiteCommand();
  sqCommand.Connection = sqConnection;
  SQLiteTransaction myTrans;

  // Start a local transaction
  myTrans = sqConnection.BeginTransaction(IsolationLevel.Serializable);
  // Assign transaction object for a pending local transaction
  sqCommand.Transaction = myTrans;

  try
  {
    sqCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')";
    sqCommand.ExecuteNonQuery();
    sqCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(60, 'PRODUCTION')";
    sqCommand.ExecuteNonQuery();
    myTrans.Commit();
    Console.WriteLine("Both records are written to database.");
  }
  catch(Exception e)
  {
    myTrans.Rollback();
    Console.WriteLine(e.ToString());
    Console.WriteLine("Neither record was written to database.");
  }
  finally
  {
    sqConnection.Close();
  }
}

Visual Basic

Public Sub RunSQLiteTransaction(myConnString As String)
  Dim sqConnection As New SQLiteConnection(myConnString)
  sqConnection.Open()

  Dim sqCommand As New SQLiteCommand()
  sqCommand.Connection = sqConnection
  Dim myTrans As SQLiteTransaction

  ' Start a local transaction
  myTrans = sqConnection.BeginTransaction(IsolationLevel.Serializable)
  ' Assign transaction object for a pending local transaction
  sqCommand.Transaction = myTrans

  Try
    sqCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"
    sqCommand.ExecuteNonQuery()
    sqCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(60, 'PRODUCTION')"
    sqCommand.ExecuteNonQuery()
    myTrans.Commit()
    Console.WriteLine("Both records are written to database.")
  Catch e As Exception
    myTrans.Rollback()
    Console.WriteLine(e.ToString())
    Console.WriteLine("Neither record was written to database.")
  Finally
    sqConnection.Close()
  End Try
End Sub

Reference

SQLiteConnection Class
SQLiteConnection Members
Overload List
SQLiteCommand Class
SQLiteTransaction Class
Commit Method
Rollback Method

Send Feedback