BelhardTraining.ConnectionPoolingDemo.MainWindowPresenter.DropDatabases C# (CSharp) Метод

DropDatabases() приватный Метод

private DropDatabases ( string connectionString, IList databases ) : void
connectionString string
databases IList
Результат void
        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();
                }
            }
        }