private Database createDB(Connection conn, string dbName, string dbFilePath) { Server svr = conn.server(); if (svr.Databases.Contains(dbName) == true) { // drop it like it's hot try { Console.WriteLine("Database [" + dbName + "] exists. Drop it? Y/n"); string ok = Console.ReadLine(); if (ok.ToLower() == "y") { //svr.KillDatabase(dbName); Console.WriteLine("Dropping [" + dbName + "]"); Database dropme = svr.Databases[dbName]; dropme.Drop(); } else { return null; } } catch (Exception e) { Console.WriteLine("Didn't drop database [" + dbName + "]"); Console.WriteLine("Database may be in use. Try this command again. Otherwise, try dropping the database manually using SQL Server Management Studio, then try again."); //Console.WriteLine(e); svr.KillDatabase(dbName); return null; } } // create new db Database db = conn.database(dbName); try { Console.WriteLine("Creating new database [" + dbName + "]"); db.Create(); } catch (Exception e) // permissions? { Console.WriteLine("ERROR - create database failed."); Console.WriteLine(e.InnerException); return null; } return db; }