/// <summary>
/// Attempts to create a new schema using a connection related to the parameters in the dialog.
/// </summary>
/// <param name="schemaName">The name of the new schema.</param>
/// <returns><c>true</c> if the schema is created successfully, <c>false</c> otherwise.</returns>
private bool CreateSchema(string schemaName)
{
bool success = true;
try
{
using (var conn = new MySqlConnectionSupport())
{
var connectionStringBuilder = new MySqlConnectionStringBuilder(ConnectionString)
{
Database = string.Empty
};
conn.Initialize(null);
conn.ConnectionString = connectionStringBuilder.ConnectionString;
conn.Open(false);
conn.ExecuteWithoutResults(string.Format("CREATE DATABASE `{0}`", schemaName), 1, null, 0);
}
}
catch (Exception ex)
{
success = false;
MySqlSourceTrace.WriteAppErrorToLog(ex, Resources.ErrorTitle, string.Format(Resources.ErrorAttemptingToCreateDB, schemaName), true);
}
return(success);
}
private bool AttemptToCreateDatabase()
{
bool flag;
MySqlConnectionProperties connectionProperties = (MySqlConnectionProperties)(base.ConnectionProperties);
DbConnectionStringBuilder connectionStringBuilder = connectionProperties.ConnectionStringBuilder;
string str = (string)connectionStringBuilder["Database"];
connectionStringBuilder["Database"] = "";
try
{
using (MySqlConnectionSupport support = new MySqlConnectionSupport())
{
support.Initialize(null);
support.ConnectionString = connectionStringBuilder.ConnectionString;
support.Open(false);
support.ExecuteWithoutResults("CREATE DATABASE `" + this.dbList.Text + "`", 1, null, 0);
}
flag = true;
}
catch (Exception)
{
MessageBox.Show(string.Format("There was an error attempting to create the database '{0}'", this.dbList.Text));
flag = false;
}
finally
{
connectionStringBuilder["Database"] = str;
}
return(flag);
}
