This is just a quick post to point out an excellent one by my friend (and former co-worker) DevPrime. He writes about a technique for Using SQL Server Files for Unit Testing in VS2005 TS. Not to blow the article too much, but his idea is to create SQL Server Compact Edition files with your tests. I imagine this would probably work xUnit-based testing as well.
In fact he beat me to the punch, I had been thinking about writing an utility to take snapshots of SQL server and create a SQL Server CE file from it... I guess there's still room for the utility (and if I was TDD I'd have already written the utility).
Technorati Tags: SQL Server, Unit Testing, Unit Testing Database, SQl Server CE