Hello everyone,

I did a search on the forums in Beginning ASP and Professional ASP regarding the ability to use transactions to encapsulate multiple CRUD statements to be executed together or not at all. But it turned up no results.

So here goes:
Using a simple example, suppose I needed to do an insert into two related tables at once within a relational SQL Server database (e.g. 2012). And suppose I wanted to do it in Linq to Entities instead of a stored procedure. Can it be done? If so, is it as reliable as using a transaction block within a stored procedure? Are there any performance or quality issues with doing it that way?

Thanks!

Keywords (for anyone who does a similar search on this concept):
Entity Framwork Transaction
SQL Server Transaction in LINQ to Entities
Multiple inserts rollback in LINQ

Hi there,

Since this is not directly to my book, please post questions like these in a more general ASP.NET / .NET category from this list: http://p2p.wrox.com/asp-net-4-5-709/

That said, you can use a TransactionScope as explained here:

http://msdn.microsoft.com/en-us/libr...vs.100%29.aspx

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!