In part 1, I showed a complicated mechanism for performing a clean database build.
There’s an easier way. The easier way is to use the msbuild extension tasks out on codeplex. While you’ll still need to forcibly take the database offline (ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE), the other msbuild tasks more easily allow you to create and delete the database. Eventually, I’ll post an example. 