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);
};
}
}