Last post Apr 15, 2015 03:08 AM by Krunal Parekh
Mar 22, 2015 04:25 PM|Malik.N.Sh|LINK
What is the differences between DbContextTransaction and TransactionScope ?
Mar 23, 2015 02:44 AM|Kevin Shen - MSFT|LINK
Wraps access to the transaction object on the underlying store connection and ensures that the Entity Framework executes commands on the database within the context of that transaction. An instance of this class is retrieved by calling BeginTransaction()
The TransactionScope’s default constructor is, for the purposes of SQL Sever database programming, broken. TransactionScope’s default constructor defaults the isolation level to Serializable and the timeout to 1 minute. IMO both these settings are harmful
when working against SQL Server.
Please refer to the link below for more detailed information :
Mar 23, 2015 02:53 AM|Malik.N.Sh|LINK
Good point , but as what is mentioned in the link , we can change the default setting to take control on things like timeout and transaction isolation level ?
Apr 15, 2015 03:08 AM|Krunal Parekh|LINK
Yes. You can please see