Entity Framwork Transaction (committ/rollback)
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?
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