public void TryLoadDatabases()
{
try
{
var builder = new SqlConnectionStringBuilder();
builder.DataSource = Model.Server;
builder.IntegratedSecurity = !Model.IsSqlServerSecurity;
if (Model.IsSqlServerSecurity)
{
builder.UserID = Model.Username;
builder.Password = Model.Password;
}
builder.InitialCatalog = "master";
var helper = new DbHelper(builder.ConnectionString);
var databases = helper.ExecuteArray<string>("select [name] from sys.databases where name not in ('master', 'tempdb','model','msdb') order by [name]");
DatabasesComboBox.ItemsSource = databases;
}
catch (Exception ex)
{
MessageBox.Show("The following error occurred while trying to populate the list of databases:\t\t" + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
