public void CreateDatabase() { using (var conn = new NpgsqlConnection(ConnectionString)) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = string.Format(@"SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = '{0}'; DROP DATABASE IF EXISTS {0}; CREATE DATABASE {0};", DatabaseName); cmd.ExecuteNonQuery(); } } try { EngineProviderFactory.RunEmbeddedScript(this, "CreateTestData_postgres.sql"); } catch { EngineProviderFactory.RunEmbeddedScript(this, "CreateTestData_postgres.sql"); } }
public void CreateDatabase() { // force close LINQ SQL connection SqlConnection.ClearAllPools(); string dbname = DatabaseName; using (var conn = OpenConnection(false)) { using (var cmd = conn.CreateCommand()) { cmd.CommandText = String.Format( @" IF EXISTS(SELECT name FROM sys.databases WHERE name='{0}') BEGIN ALTER DATABASE {0} SET SINGLE_USER WITH ROLLBACK IMMEDIATE; USE master; DROP DATABASE {0}; END USE master; CREATE DATABASE {0}", dbname); cmd.ExecuteNonQuery(); } } SqlConnection.ClearAllPools(); EngineProviderFactory.RunEmbeddedScript(this, "CreateTestData_mssql.sql"); }
public void CreateDatabase() { if (File.Exists("dbshelltest.sqlite")) { File.Delete("dbshelltest.sqlite"); } using (var db = OpenConnection()) { EngineProviderFactory.RunEmbeddedScript(this, "CreateTestData_sqlite.sql"); } }
public void CreateDatabase() { using (var conn = new MySqlConnection(ConnectionString)) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = $"DROP DATABASE IF EXISTS `{DatabaseName}`; CREATE DATABASE {DatabaseName};"; cmd.ExecuteNonQuery(); } } EngineProviderFactory.RunEmbeddedScript(this, "CreateTestData_mysql.sql"); }