Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
liptonIcedTea
Starting Member
26 Posts |
 Posted - 2008-05-13 : 02:40:16
|
| Hi,I'm doing some unit testing using a .NET interface.how I'm doing this is to create a transaction whenever I begin a test, and to roll it back whenever I finish with it. That way i can do whatever I want to the database, and it will get reverted.The only problem I have is... some of my methods already implement transactions because they may need to call multiple queries or stored procedures.Im unsure of how transactions work, but is it possible to make a transaction inside a transaction? So the test itself would be transaction, (which gets rolled back after the test finishes) and then there will also be one or more transaction inside the test itself?Thanks |
|
|
|
|
|
transaction inside a transaction