Execute unit tests against DB and keep it unchanged.
In my old post I explained how you can create a NUnit add-in for reverting changes in database made by unit tests. In this add-in I use TransactionScope class to open a MSDTC transaction and rollback changes made by the unit test. I found this approach time consuming and unpredictable (sometimes my tests doesn’t work [...]