Galen.Ci.EntityFramework.DbDeploymentManager.GetIsTargetDatabaseExists C# (CSharp) Method

        private bool GetIsTargetDatabaseExists()
        {
            
            const string sql = "SELECT 1 FROM sys.databases WHERE name = @DatabaseName";

            var factory = DbProviderFactories.GetFactory(m_ConnectionInfoBuilder.ProviderName);
            using (var connection = factory.CreateConnection())
            {
                var masterDatabase = new DatabaseEndpoint
                {
                    DatabaseName = "master",
                    ServerName = m_Config.Database.ServerName
                };

                connection.ConnectionString = m_ConnectionInfoBuilder.BuildConnectionString(
                    masterDatabase,
                    m_Config.AuthMode,
                    m_Config.SqlLogin,
                    m_Config.SqlPassword);


                using (var command = connection.CreateCommand())
                {
                    command.CommandText = sql;

                    var databaseNameParam = command.CreateParameter();
                    databaseNameParam.DbType = DbType.String;
                    databaseNameParam.Direction = ParameterDirection.Input;
                    databaseNameParam.ParameterName = "@DatabaseName";
                    databaseNameParam.Value = m_Config.Database.DatabaseName;
                    command.Parameters.Add(databaseNameParam);

                    connection.Open();

                    var result = (int?)command.ExecuteScalar();
                    connection.Close();

                    return (result == 1);
                };
            }
        }