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

        public void RunPoolTest()
        {
            try
            {
                string masterConnectionString = BuildConnectionString("master");
                List<string> databases = CreateDatabases(masterConnectionString, ToolSettings.NumDatabases);
                if (databases.Count != ToolSettings.NumDatabases)
                {
                    DropDatabases(masterConnectionString, databases);
                    return;
                }

                const string sqlQuery = "SELECT 'SessionID=' + CAST(@@SPID AS varchar(20))";

                _perfCounters = InitPerformanceCounters();
                WritePerformanceCounters();

                foreach (string dbName in databases)
                {
                    using (SqlConnection sqlConn = new SqlConnection(BuildConnectionString(dbName)))
                    {
                        var sqlCmd = new SqlCommand(sqlQuery, sqlConn);

                        sqlConn.Open();
                        _viewModel.LogLines.AddLine((string)sqlCmd.ExecuteScalar());
                    }
                }
                WritePerformanceCounters();

                //connectionString = BuildConnectionString("master");
                //for (int i = 0; i < 10; i++)
                //{
                //	using (SqlConnection sqlConn = new SqlConnection(connectionString))
                //	{
                //		var sqlCmd = new SqlCommand(sqlQuery, sqlConn);

                //		sqlConn.Open();
                //		tbQueryOutput.AppendText((string)sqlCmd.ExecuteScalar() + "\r\n");
                //	}
                //}
                //WritePerformanceCounters();

                DropDatabases(masterConnectionString, databases);

                _viewModel.LogLines.AddLine("");
                _viewModel.LogLines.AddLine("Тестирование закончено");
            }
            finally
            {
                _viewModel.PoolTestRunning = false;
            }
        }