How does the transaction scope work? How does it know when there is another context being used already and how might I implement another kind of scope in my code. I'm primarily a vb.net developer but I can read the c# if you write in that. In case the above was too vague: I understand what system.transactions does and how to use it. ...
I have "inherited" a little C# method that creates an ADO.NET SqlCommand object and loops over a list of items to be saved to the database (SQL Server 2005). Right now, the traditional SqlConnection/SqlCommand approach is used, and to make sure everything works, the two steps (delete old entries, then insert new ones) are wrapped into a...
We are using Entity Framework and running unit tests within a transaction scope. We were origianally getting the error in the title. I have managed to isolate the problem some what. using (TransactionScope scope1 = new TransactionScope()) { using (TransactionScope scope2 = new TransactionScope()) ...
Is it possible to have a hierarchy of transaction scopes? If the outer transaction scope does a dispose, what will happen to changes made in the inner transaction scope? My particular problem is that I have test code that runs code that has a transaction scope. When I call a second set of code with a transaction scope I get "Cannot acc...