public static void CreateDatabase(out MycoKeyCreator.Library.Database.IDatabase iDatabase, string dataSource, bool useWindowsAuthentication, string userName, string password, string folder, string dbName)
{
// Connect to the master DB to create the requested database
OpenDatabase(out PetaPoco.NetCore.Database database, true, dataSource, null, -1, useWindowsAuthentication, userName, password, "master");
SqlQueryBuilders.SqlServerQueryBuilder iSqlQueryBuilder = new SqlQueryBuilders.SqlServerQueryBuilder();
database.Execute(iSqlQueryBuilder.CreateDatabase(folder, dbName));
database.CloseSharedConnection();
// Connect to the new database
OpenDatabase(out database, true, dataSource, null, -1, useWindowsAuthentication, userName, password, dbName);
iDatabase = new DatabaseWrapper(database);
iDatabase.ISqlQueryBuilder = iSqlQueryBuilder;
// Create each table
iDatabase.CreateTables();
}
public static void CreateDatabase(out MycoKeyCreator.Library.Database.IDatabase iDatabase, string server, int port, bool useWindowsAuthentication, string userName, string password, string dbName)
{
// Connect to the master DB to create the requested database
OpenDatabase(out PetaPoco.NetCore.Database database, server, port, useWindowsAuthentication, userName, password, "MySql");
SqlQueryBuilders.MySqlQueryBuilder iSqlQueryBuilder = new SqlQueryBuilders.MySqlQueryBuilder();
database.Execute(@"CREATE DATABASE " + dbName);
database.CloseSharedConnection();
// Connect to the new database
OpenDatabase(out database, server, port, useWindowsAuthentication, userName, password, dbName);
iDatabase = new DatabaseWrapper(database);
iDatabase.ISqlQueryBuilder = iSqlQueryBuilder;
// Create each table
iDatabase.CreateTables();
}
