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