public static NpgsqlConnection CreateConnection()
{
var conn = new NpgsqlConnection(DatabaseConstants.ConnectionString);
conn.Open();
conn.RegisterEnum<ActionType>("actiontype");
return conn;
}
public void ReloadTypes()
{
using (var conn = new NpgsqlConnection(ConnectionString))
{
conn.Open();
Assert.That(ExecuteScalar("SELECT EXISTS (SELECT * FROM pg_type WHERE typname='reload_types_enum')"), Is.False);
ExecuteNonQuery("CREATE TYPE pg_temp.reload_types_enum AS ENUM ('First', 'Second')");
conn.ReloadTypes();
conn.RegisterEnum<ReloadTypesEnum>("reload_types_enum");
}
}
