Hi Travis.
I wronte an article on a simple way to achieve this in .NET on MSDN Magazine:
http://msdn.microsoft.com/msdnmag/issues/05/06/UnitTesting/
you can also check out these:
http://weblogs.asp.net/rosherove/articles/dbunittesting.aspx
Also - look up mbUnit" - it has a "rollback" attribute which I helped create that allows seamless rollback of database.
You might have guessed - I'm pro testing *with* the datbase (meaning -Integration Testing the data layer.
I'm also in he midst of writing the book "Art Of Unit Testing" which will deal with this issue as well.
Roy.
Thank you Roy, I'll definatly check out those resources. And I'll wait patiently for your book... :-)