Using auto-configured localdb for unit testing; how do I clean up?

Question

I've configured an .mdf file along with a localdb connection string for use in unit tests, like this:

<connectionStrings>
        <add name="TestData" providerName="System.Data.SqlClient" connectionString="Data Source=(localdb)\v11.0; AttachDBFilename='|DataDirectory|\TestData.mdf'; Integrated Security=True"/>
</connectionStrings>

Once I've configured deployment files for my test correctly, this works beautifully: a copy of the .mdf is attached to the default instance of LocalDB, and the SqlClient connects to it without a shred of configuration. It just works.

But how do I clean up afterwards? On my local box, I can periodically use SSMS to manually detach old testing databases, but on a CI server it would obviously be preferable to have the unit test clean itself up.

Is there a similarly automagic way to cause a localdb database to detach itself from the instance?

Answer 1

This is how I am deleting the localDB database. The thing I don't like is that the .mdf is also removed. I overcome that by copying it to a tem directory first and using the copy to create the db.

var sc = new Microsoft.SqlServer.Management.Common.ServerConnection(your localDB SqlConnection here);
var server = new Microsoft.SqlServer.Management.Smo.Server(sc);
server.KillDatabase(dbName here);

Hope this helps Phil