How do I create and drop a database defined using Visual Studio Team System Database Edition from inside a unit test? (I guess that makes it more of a integration test...)
I want to be able to create the database either for each test or for a suite of tests and then drop the database after each test or suite of tests.
Is there an API I can use or do I have to run all the scripts myself? In case of an API I will need to specify the name of the database and the server instance.