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