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