private void btnNewDatabase_Click(object sender, RoutedEventArgs e)
{
string connectionString = getConnectionString();
string rootPath = SqlMetadataStore.GetSqlPath(connectionString);
var createDatabaseForm = new CreateDatabase(rootPath);
if (createDatabaseForm.ShowDialog().GetValueOrDefault())
{
SqlMetadataStore.CreateDatabase(connectionString,
createDatabaseForm.DatabaseName,
createDatabaseForm.DatabaseFile,
createDatabaseForm.LogFile
);
_config.SetValue(FileSystemBlobStore.BLOB_ROOT_PATH, System.IO.Path.Combine(rootPath, createDatabaseForm.DatabaseName + "_Files"));
}
}
private void wizDatabaseCreate_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
var createDatabaseTask = new Task(() =>
{
try
{
using (var localDB = new SqlLocalDbApi())
{
ReportStatus("Searching for Localdb instance", 1);
ReportStatus("Checking default Instance", 2);
var connected = false;
string instance = localDB.DefaultInstanceName;
List <string> instanceNames = new List <string>(localDB.GetInstanceNames());
instanceNames = instanceNames.Where(n => n != instance).ToList(); // only non-default instances
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
int iInstance = 0;
while (!connected)
{
builder.DataSource = $"(LocalDb)\\{instance}";
builder.InitialCatalog = "Master";
builder.IntegratedSecurity = true;
ReportStatus($"Connecting to {instance}", 2);
var con = new SqlConnection(builder.ConnectionString);
try
{
con.Open();
connected = true;
}
catch
{
connected = false;
if (iInstance >= instanceNames.Count)
{
ReportStatus("Error: No LocalDb database instances could be connected to.", 0);
return;
}
instance = instanceNames[iInstance];
iInstance++;
}
}
ReportStatus($"Successfully connected to {instance}", 20);
string databaseName = "Placeless";
int i = 0;
var databaseNames = getDatabaseList(builder.ConnectionString);
string mdf = System.IO.Path.Combine(txtDatabasePath.Text, $"{databaseName}.mdf");
string ldf = System.IO.Path.Combine(txtDatabasePath.Text, $"{databaseName}.ldf");
ReportStatus($"Selecting a unique database name", 30);
while (
System.IO.File.Exists(mdf) ||
System.IO.File.Exists(ldf) ||
databaseNames.Contains(databaseName)
)
{
i++;
databaseName = $"Placeless{i:D2}";
mdf = System.IO.Path.Combine(txtDatabasePath.Text, $"{databaseName}.mdf");
ldf = System.IO.Path.Combine(txtDatabasePath.Text, $"{databaseName}.ldf");
}
ReportStatus($"Creating database {databaseName}.", 35);
ReportStatus($"Data File: {mdf}", 35);
ReportStatus($"Log File: {ldf}", 35);
SqlMetadataStore.CreateDatabase(builder.ConnectionString, databaseName, mdf, ldf);
builder.InitialCatalog = databaseName;
ReportStatus($"Database Created, migrating", 80);
var _dbContextOptions = SqlServerDbContextOptionsExtensions.UseSqlServer(
new DbContextOptionsBuilder(),
builder.ConnectionString,
options => options.CommandTimeout(120)
).Options;
using (var dbContext = new ApplicationDbContext(_dbContextOptions))
{
dbContext.Database.Migrate();
}
ReportStatus($"Migrations executed, updating config", 90);
_config.SetValue(SqlMetadataStore.CONNECTION_STRING_SETTING, builder.ConnectionString);
_config.SetValue(FileSystemBlobStore.BLOB_ROOT_PATH, System.IO.Path.Combine(txtDatabasePath.Text, $"{databaseName}_Files"));
ReportStatus($"Configuration Updated", 100);
this.Invoke((MethodInvoker) delegate
{
wizardControl1.NextPage();
});
}
}
catch (Exception ex)
{
this.Invoke((MethodInvoker) delegate
{
txtCreateDatabaseOutput.Text += ex.Message + "\r\n";
txtCreateDatabaseOutput.Text += ex.StackTrace + "\r\n";
});
}
}, TaskCreationOptions.LongRunning);
createDatabaseTask.Start();
}
