dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteConnection Class / Rollback Method
Example

In This Topic
    Rollback Method (SQLiteConnection)
    In This Topic
    Rolls back a transaction from a pending state.
    Syntax
    'Declaration
     
    Public Sub Rollback() 
    public void Rollback()
    Example
    The following example demonstrates how to use Commit and Rollback methods.
    public void RunSQLiteTransaction(string myConnString)
    {
      SQLiteConnection sqConnection = new SQLiteConnection(myConnString);
      sqConnection.Open();
    
      SQLiteCommand sqCommand = new SQLiteCommand();
      sqConnection.BeginTransaction();
      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();
        sqConnection.Commit();
        Console.WriteLine("Both records are written to database.");
      }
      catch(Exception e)
      {
        sqConnection.Rollback();
        Console.WriteLine(e.ToString());
        Console.WriteLine("Neither record was written to database.");
      }
      finally
      {
        sqConnection.Close();
      }
    }
    Public Sub RunSQLiteTransaction(myConnString As String)
      Dim sqConnection As New SQLiteConnection(myConnString)
      sqConnection.Open()
    
      Dim sqCommand As New SQLiteCommand()
      sqConnection.BeginTransaction()
      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()
        sqConnection.Commit()
        Console.WriteLine("Both records are written to database.")
      Catch e As Exception
        sqConnection.Rollback()
        Console.WriteLine(e.ToString())
        Console.WriteLine("Neither record was written to database.")
      Finally
        sqConnection.Close()
      End Try
    End Sub
    See Also