Will a using statement rollback a database transaction if an error occurs?

by

Dispose method for transaction class performs a rollback while Oracle’s class doesn’t. So from transaction’s perspective it’s implementation dependent.

The using statement for the connection object on the other hand would either close the connection to the database or return the connection to the pool after resetting it. In either case, the outstanding transactions should be rolled back. That’s why an exception never leaves an active transaction lying around.

Also, yes, you should call Commit() explicitly.

More Related Contents:

  1. What are the uses of “using” in C#?
  2. What is the C# Using block and why should I use it? [duplicate]
  3. The type or namespace name could not be found [duplicate]
  4. TransactionScope automatically escalating to MSDTC on some machines?
  5. Using Transactions or SaveChanges(false) and AcceptAllChanges()?
  6. SqlException from Entity Framework – New transaction is not allowed because there are other threads running in the session
  7. Transactions in .net
  8. ‘using’ statement vs ‘try finally’
  9. try/catch + using, right syntax
  10. TransactionScope vs Transaction in LINQ to SQL
  11. returning in the middle of a using block
  12. What happens if i return before the end of using statement? Will the dispose be called?
  13. SqlCommand with using statement
  14. Does Dispose still get called when exception is thrown inside of a using statement?
  15. Why use a using statement with a SqlTransaction?
  16. The C# using statement, SQL, and SqlConnection
  17. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  18. Do using statements and await keywords play nicely in c#
  19. How to use TransactionScope in C#?
  20. Entity Framework 6 transaction rollback
  21. What and when is “using” block used for in C#? How to use “using” block in C#?
  22. How does TransactionScope roll back transactions?
  23. When is “using” block used for in C#? How to use “using” block in C#?
  24. When should I use the using Statement? [duplicate]
  25. “The operation is not valid for the state of the transaction” error and transaction scope
  26. How to handle WCF exceptions (consolidated list with code)
  27. TransactionScope With Files In C# [duplicate]
  28. C# – System.Transactions.TransactionScope
  29. using statement with multiple variables [duplicate]
  30. What is the difference between User Control, Custom Control and Component?

Leave a Comment