dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlConnection Class / Rollback Method
Example

On this page
    Rollback Method (MySqlConnection)
    On this page
    Rolls back a transaction from a pending state.
    Syntax
    'Declaration
     
    Public Sub Rollback() 
    public void Rollback()
    Remarks

    In MySQL, only InnoDB and BDB (BerkeleyDB) table formats support transactions. Other standard storage engines ignore transactions and can not rollback data modifications.

    Example
    The following example demonstrates how to use Commit and Rollback methods.
    public void RunMySqlTransaction(string myConnString)
    {
      MySqlConnection mySqlConnection = new MySqlConnection(myConnString);
      mySqlConnection.Open();
    
      MySqlCommand mySqlCommand = new MySqlCommand();
      mySqlConnection.BeginTransaction();
      try
      {
        mySqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')";
        mySqlCommand.ExecuteNonQuery();
        mySqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')";
        mySqlCommand.ExecuteNonQuery();
        mySqlConnection.Commit();
        Console.WriteLine("Both records are written to database.");
      }
      catch(Exception e)
      {
        mySqlConnection.Rollback();
        Console.WriteLine(e.ToString());
        Console.WriteLine("Neither record was written to database.");
      }
      finally
      {
        mySqlConnection.Close();
      }
    }
    Public Sub RunMySqlTransaction(myConnString As String)
      Dim mySqlConnection As New MySqlConnection(myConnString)
      mySqlConnection.Open()
    
      Dim mySqlCommand As New MySqlCommand()
      mySqlConnection.BeginTransaction()
      Try
        mySqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"
        mySqlCommand.ExecuteNonQuery()
        mySqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')"
        mySqlCommand.ExecuteNonQuery()
        mySqlConnection.Commit()
        Console.WriteLine("Both records are written to database.")
      Catch e As Exception
        mySqlConnection.Rollback()
        Console.WriteLine(e.ToString())
        Console.WriteLine("Neither record was written to database.")
      Finally
        mySqlConnection.Close()
      End Try
    End Sub
    See Also