public string BuildConnectionString(DatabaseEndpoint endpoint, AuthenticationMode authMode, string sqlLogin = null, string sqlPassword = null)
{
var connectionStringBuilder = new SqlConnectionStringBuilder
{
DataSource = endpoint.ServerName,
ApplicationName = "Galen.Ci.EntityFramework"
};
if (authMode == AuthenticationMode.Integrated)
{
connectionStringBuilder.IntegratedSecurity = true;
}
else
{
connectionStringBuilder.UserID = sqlLogin;
connectionStringBuilder.Password = sqlPassword;
}
if (!string.IsNullOrEmpty(endpoint.DatabaseName))
{
connectionStringBuilder.InitialCatalog = endpoint.DatabaseName;
}
return(connectionStringBuilder.ConnectionString);
}
public string BuildConnectionString(DatabaseEndpoint endpoint, AuthenticationMode authMode, string sqlLogin = null, string sqlPassword = null)
{
var connectionStringBuilder = new SqlConnectionStringBuilder
{
DataSource = endpoint.ServerName,
ApplicationName = "Galen.Ci.EntityFramework"
};
if (authMode == AuthenticationMode.Integrated)
{
connectionStringBuilder.IntegratedSecurity = true;
}
else
{
connectionStringBuilder.UserID = sqlLogin;
connectionStringBuilder.Password = sqlPassword;
}
if (!string.IsNullOrEmpty(endpoint.DatabaseName))
{
connectionStringBuilder.InitialCatalog = endpoint.DatabaseName;
}
return connectionStringBuilder.ConnectionString;
}
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);
};
}
}
public DbConnectionInfo Build(DatabaseEndpoint endpoint, AuthenticationMode authMode, string sqlLogin = null, string sqlPassword = null)
{
return(new DbConnectionInfo(BuildConnectionString(endpoint, authMode, sqlLogin, sqlPassword), ProviderName));
}
public DbConnectionInfo Build(DatabaseEndpoint endpoint, AuthenticationMode authMode, string sqlLogin = null, string sqlPassword = null)
{
return new DbConnectionInfo(BuildConnectionString(endpoint, authMode, sqlLogin, sqlPassword), ProviderName);
}
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);
};
}
}
