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

On this page
    Commit Method (MySqlConnection)
    On this page
    Commits the database transaction.
    Syntax
    'Declaration
     
    Public Sub Commit() 
    public void Commit()
    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();
      mySqlCommand.Connection = mySqlConnection;
      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()
      mySqlCommand.Connection = mySqlConnection
      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