Transactions in Web applications
-
How transactions are handled in web applications you worked with? Using ADO.NET [BeginTransaction], Stored Procedure [TCL] or Entity Framework [SaveChanges() to insert, update or delete on the database which is wrapped in a transaction] or any other way? Please share your experiences and learnings on this topic. Thanks a lot in advance.
-
How transactions are handled in web applications you worked with? Using ADO.NET [BeginTransaction], Stored Procedure [TCL] or Entity Framework [SaveChanges() to insert, update or delete on the database which is wrapped in a transaction] or any other way? Please share your experiences and learnings on this topic. Thanks a lot in advance.
I prefer Stored Procedure, handle things inside procedure & returns things to UI. If your project not using Stored procedure, ADO.NET transaction is alternative. These article could help you more. All About TransactionScope[^] A Beginner's Tutorial for Understanding Transactions and TransactionScope in ADO.NET[^] I never worked with Entity Framework. Check this MSDN page How to: Manage Transactions in the Entity Framework[^]
thatraja
Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
-
I prefer Stored Procedure, handle things inside procedure & returns things to UI. If your project not using Stored procedure, ADO.NET transaction is alternative. These article could help you more. All About TransactionScope[^] A Beginner's Tutorial for Understanding Transactions and TransactionScope in ADO.NET[^] I never worked with Entity Framework. Check this MSDN page How to: Manage Transactions in the Entity Framework[^]
thatraja
Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
Thanks for your reply. I will visit the links and figure out best for me.