How to implement nested SQL transactions with ADO.NET?
- by manza_jurjur
I need to implement nested transactions in .NET using ADO.NET.
The situation is as follows:
--> Start Process (Begin Transaction)
--> Begin Transaction for step 1
--> Step 1
--> Commit transaction for step 1
--> Begin transaction for step 2
--> Step 2
--> Rollback transaction for step 2
--> etc ...
--> End Process (Commit or Rollback ALL commited steps)
Can that be done with transaction scopes? Could anyone post an example?
In addition I'd need the prcoess to work for SQL Server 2005 AND Oracle 10g databases... will transaction scopes work with both database engines?
