I am a little perplexed right at the moment. If I am to isolate all my unit tests and leave the testing environment as it was at the beginning of my test, how can I add records to a database? Won’t my PK sequence bugger things up if I am using IDENTITY primary keys?

There is a little voice in my head screaming “Transactions”. More investigation! So some time passes, google churns and out pops DataFresh. At first glance it would seem to be a solution to returning the database to it’s pre-test state. Or not doing so as the case may be, which seems key to perfomance.

I was pleased to drill a bit into the site and find that Roy Oshergrove has given the folks at Entropy Zero a look.