How does TransactionScope roll back transactions?

by

Essentially TransactionScope doesn’t track your Adapter’s, what it does is it tracks database connections. When you open a DB connection the connections will looks if there is an ambient transaction (Transaction Scope) and if so enlist with it. Caution if there are more the one connection to the same SQL server this will escalate to a Distribtued Transaction.

What happens since you’re using a using block you are ensuring dispose will be called even if an exception occurs. So if dispose is called before txScope.Complete() the TransactionScope will tell the connections to rollback their transactions (or the DTC).

More Related Contents:

  1. TransactionScope automatically escalating to MSDTC on some machines?
  2. How to use TransactionScope in C#?
  3. “The operation is not valid for the state of the transaction” error and transaction scope
  4. C# – System.Transactions.TransactionScope
  5. Transactions in .net
  6. Identifying NHibernate proxy classes
  7. C# controlling a transaction across multiple databases
  8. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  9. Polymorphism: Is ORM entity a Domain Entity or Data Entity?
  10. NHibernate.MappingException: No persister for: XYZ
  11. TransactionScope With Files In C# [duplicate]
  12. How to create an object during runtime in .net
  13. Creating a DateTime in a specific Time Zone in c#
  14. How can I send emails through SSL SMTP with the .NET Framework?
  15. How to get the index of an element in an IEnumerable?
  16. Json.NET serialize object with root name
  17. C# “internal” access modifier when doing unit testing
  18. Async/Await vs Threads
  19. How to serialize/deserialize simple classes to XML and back
  20. Fastest way to add new node to end of an xml?
  21. Should I transform Entity (Persistent) objects to DTO objects?
  22. How to Get XML Node from XDocument
  23. GC.Collect() and Finalize
  24. Possible pitfalls of using this (extension method based) shorthand
  25. Total number of items defined in an enum
  26. Protect .NET code from reverse engineering?
  27. string.Empty vs null.Which one do you use?
  28. How to get DPI in C# .NET?
  29. Dynamically loading resource dictionary files to a wpf application gives an error
  30. Create a completed Task

Leave a Comment