Bug. Ef Core cannot translate postgresql Array functions when used optimized EF Core Model

[megafetis]

Whe i use Optimized DbContext: dotnet ef dbcontext optimize --context MainDbContext Postgresql array functions cannot translate to sql:

I tried to use many funtions from documentation https://www.npgsql.org/efcore/mapping/array.html. Works only this: String.Join(separator, array) I use NET 8

[roji]

@megafetis please post a minimal, runnable console program that shows the problem. Screenshots of partial code snippets aren't helpful.

[megafetis]

@megafetis please post a minimal, runnable console program that shows the problem. Screenshots of partial code snippets aren't helpful.

@roji Hello, take a link to test app: https://github.com/megafetis/NpgsqlEfCoreBugConsoleApp1

[roji]

Thanks for providing the repro, and sorry it took so long to get around to investigating this. This indeed turned out to be a real bug on the EF side - I've opened https://github.com/dotnet/efcore/issues/35047 to track addressing it there.