dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlConnection Class / Rollback Method
Example

On this page
    Rollback Method (PgSqlConnection)
    On this page
    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 RunPgSqlTransaction(string myConnString)
    {
      PgSqlConnection pgSqlConnection = new PgSqlConnection(myConnString);
      pgSqlConnection.Open();
    
      PgSqlCommand pgSqlCommand = new PgSqlCommand();
      pgSqlConnection.BeginTransaction();
      try
      {
        pgSqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')";
        pgSqlCommand.ExecuteNonQuery();
        pgSqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')";
        pgSqlCommand.ExecuteNonQuery();
        pgSqlConnection.Commit();
        Console.WriteLine("Both records are written to database.");
      }
      catch(Exception e)
      {
        pgSqlConnection.Rollback();
        Console.WriteLine(e.ToString());
        Console.WriteLine("Neither record was written to database.");
      }
      finally
      {
        pgSqlConnection.Close();
      }
    }
    Public Sub RunPgSqlTransaction(myConnString As String)
      Dim pgSqlConnection As New PgSqlConnection(myConnString)
      pgSqlConnection.Open()
    
      Dim pgSqlCommand As New PgSqlCommand()
      pgSqlConnection.BeginTransaction()
      Try
        pgSqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"
        pgSqlCommand.ExecuteNonQuery()
        pgSqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')"
        pgSqlCommand.ExecuteNonQuery()
        pgSqlConnection.Commit()
        Console.WriteLine("Both records are written to database.")
      Catch e As Exception
        pgSqlConnection.Rollback()
        Console.WriteLine(e.ToString())
        Console.WriteLine("Neither record was written to database.")
      Finally
        pgSqlConnection.Close()
      End Try
    End Sub
    See Also