It seems that I need some help from EF guru. So, I have Postgres DB with EF Core in my project. There is a table RequestDbModel which might contain many rows with the same Id and different ts. I need to select Request collection from this table where Items are rows with the same Id and also some extra fields have to be filled from these Items ordered by ts. I can do this, but only if I am materializing the query. I believe this can be done without materializing, but I cannot figure out how and I would appreciate any help

i’m working on a Project based on Winform C# with Entity Framework, writing/reading data from a PostgreSQL database.

I work with EF core and PostgreSQL
When configuring entity i use such code

Problem Statement: