Home

Usando transação em C#

using (DbConnection connection = db.CreateConnection())
{
  connection.Open();
  DbTransaction transaction = connection.BeginTransaction();

  try
  {
    // Credit the first account.
    db.ExecuteNonQuery(creditCommand, transaction);
    // Debit the second account.
    db.ExecuteNonQuery(debitCommand, transaction);

    // Commit the transaction.
    transaction.Commit();
                   
    result = true;
  }
  catch
  {
    // Roll back the transaction.
    transaction.Rollback();
  }
  connection.Close();
               
  return result;
}

Imprimir

Enviar para um amigo

Dê sua opinião