public async Task GetDatabase()
{
SqlServerDatabaseInfo dbi = new SqlServerDatabaseInfo();
var database = await dbi.GetDatabase("Data Source=.; Database=WIGOV.DNR.ACSBS; Integrated Security=False; MultipleActiveResultSets=True; User ID=sa; Password=password1!;");
Assert.NotEmpty(database.Tables);
}
private void CreateSqlServerDatabase_OnClick(object sender, RoutedEventArgs e)
{
try
{
var sqlServerDatabaseInfo = new SqlServerDatabaseInfo
{
ServerName = sqlServer_serverName.Text,
DatabasePath = sqlServer_databasePath.Text,
Username = sqlServer_username.Text,
Password = sqlServer_password.Text
};
//sqlServerDatabaseInfo.CreateDatabase();
CreateSchema(sqlServerDatabaseInfo);
OpenSession(sqlServerDatabaseInfo);
MessageBox.Show(string.Format("Database {0} is created", sqlServer_databasePath.Text));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
