[–] logos_ethos 0 points 1 point 1 point (+1|-0) ago
Is https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL something that you can use? It supports citext, but I think that you have to change:
alter database {dbName} set search_path to 'dbo';
to
alter database {dbName} set search_path to 'dbo,public';
in both files so that the server sends back "citext" instead of "public.citext".
[–] PuttItOut ago
That is the library we use to access PostgreSQL. And I will try this among some other things to see what combo will work.
I don't know if I'll have time until tomorrow though.
[–] logos_ethos 0 points 1 point 1 point (+1|-0) ago (edited ago)
OK. I looked in the source code, and it has a map for citext in src/EFCore.PG/Storage/Internal/NpgsqlEFTypeMapper.cs. But without public in the search_path, then the server sends the schema name too, and the code probably does not handle that.
OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.HasPostgresExtension("citext"); } might be required too. I am not sure. A bug report might suggest that this is automatic and only required if citext was not there when the connection was first made.
I am installing Visual Studio on a VM with 1GB of RAM, and it is taking forever. But after that, I might be able to tweak things.