/// <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); }