Database.BeginTransaction vs Transactions.TransactionScope [duplicate]

by

I found out the answer in Entity Framework 6’s documentation:

With the introduction of EF6, Microsoft recommends to use new API methods: Database.BeginTransaction() and Database.UseTransaction(). Although System.Transactions.TransactionScope is still very well supported, it is no longer necessary for most users of EF6.

While Database.BeginTransaction() is used only for database related operations transaction, System.Transactions.TransactionScope, in addition to that, makes it possible for ‘plain C# code’ to also be transactional.

Hence, use Database.BeginTransaction() where ever doing only db related operations in a transaction in EF6 otherwise use System.Transactions.TransactionScope for mixing db operations and C# code together in a transaction.

For those who still prefer the TransactionScope approach, it is recommended they checkout its limitations, especially in cloud scenarios (cloud scenarios do not support distributed transactions).

Further information can be found here

More Related Contents:

  1. Entity Framework 6 transaction rollback
  2. TransactionScope automatically escalating to MSDTC on some machines?
  3. Using Transactions or SaveChanges(false) and AcceptAllChanges()?
  4. SqlException from Entity Framework – New transaction is not allowed because there are other threads running in the session
  5. Entity Framework Provider type could not be loaded?
  6. How to update record using Entity Framework 6?
  7. How to filter “Include” entities in entity framework?
  8. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  9. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  10. Mapping composite keys using EF code first
  11. Setting unique Constraint with fluent API?
  12. Lazy Loading vs Eager Loading
  13. Entity Framework 6: audit/track changes
  14. Dynamic MySQL database connection for Entity Framework 6
  15. Entity Framework 6 Code First Custom Functions
  16. Problems using Entity Framework 6 and SQLite
  17. Save detached entity in Entity Framework 6
  18. How to use TransactionScope in C#?
  19. Configure multiple database Entity Framework 6
  20. How does TransactionScope roll back transactions?
  21. Log Queries executed by Entity Framework DbContext
  22. How are people unit testing with Entity Framework 6, should you bother?
  23. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  24. How to group by DateTime.Date in EntityFramework
  25. “The operation is not valid for the state of the transaction” error and transaction scope
  26. How to use String property as primary key in Entity Framework
  27. TransactionScope With Files In C# [duplicate]
  28. C# – System.Transactions.TransactionScope
  29. How does the SQLite Entity Framework 6 provider handle Guids?
  30. How can set a default value constraint with Entity Framework 6 Code First?

Leave a Comment