public ConnectionWizard()
{
InitializeComponent();
sqlSchema = new SqlSchema();
#if DEBUG
cbDatabase_DropDown(this, null);
if (cbDatabase.Items.Contains("Moody"))
cbDatabase.SelectedItem = "Moody";
#endif
}
public void CreateNewDatabase(string name, SqlSchema schema, string sqlCode)
{
try
{
SqlHelper.ExecuteNonQuery(
schema.ConnectionString,
CommandType.Text,
"CREATE DATABASE [" + name + "];");
SqlHelper.ExecuteNonQuery(
schema.ConnectionString.Replace(schema.Database, name),
CommandType.Text,
sqlCode);
}
catch (Exception ex)
{
throw new Exception("Erro ao criar base de dados: " + ex.Message);
}
}
