Count on properties is evaluated on sql for each of item.

[CrazyBaran]

Steps to reproduce

I try to make count on list properties and this count query is evaluated for each of record, not as one query. It is bad performance.

db.Blogs.select(x=> new BlogsDto(){ PostsCount = x.Posts.Count})

Is there some not implemented functionality yet? I try also do this with include but also get 100 of Count query for each of Blog.
This code is simplified to get a problem.

EF Core version: 2.2.3
Database Provider: PostgreSQL

[CrazyBaran]

Ok I find duplicate #11186