void DropDatabases(string connectionString, IList<string> databases)
{
if (databases.Count == 0) return;
using (var sqlConn = new SqlConnection(connectionString))
{
sqlConn.Open();
foreach (string dbName in databases)
{
var dropCmd = new SqlCommand();
_viewModel.LogLines.AddLine("Удаление базы данных [" + dbName + "]");
dropCmd.CommandText = string.Format("ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DROP DATABASE [{0}]", dbName);
dropCmd.Connection = sqlConn;
dropCmd.ExecuteNonQuery();
}
}
}