public void Postgres_extension_is_created()
{
var connString = NpgsqlTestStore.NextScratchConnectionString();
using (var context = new ExtensionContext(connString))
{
var creator = context.GetService <IRelationalDatabaseCreator>();
creator.Create();
try
{
var cmd = context.GetService <IRawSqlCommandBuilder>().Build(
"SELECT EXISTS (SELECT * FROM pg_available_extensions WHERE name='hstore' AND installed_version IS NOT NULL);"
);
var conn = context.GetService <IRelationalConnection>();
Assert.True((bool)cmd.ExecuteScalar(conn));
}
finally
{
creator.Delete();
}
}
}
