One LINQ query to get counts from several entities when using entity framework core

Getting COUNT and SKIP TAKE in one operation with Linq to Entities

It might be feasible, but given the criteria you're applying, it probably won't be any faster. Since you're searching for text within a column value, you cannot use an index and thus must do a table scan. You run a single query to get ...all... records and then execute the...Count... and ...Skip/Take... using linq-to-objects...var queryResult = Da...

How to build several left join query in Entity Framework Core

ZZZ_tmp

Same property name in several child entities with Entity Framework Core 2.0

ZZZ_tmp

sql query on entity-framework core with sum(x-y), count(<condition>) and group

ZZZ_tmp

One-to-one and one-to-many on the same entity in Entity Framework

ZZZ_tmp

Entity Framework Core Linq query to filter related entity

ZZZ_tmp

LINQ does not produce COUNT() query on group using EF Core

ZZZ_tmp

Pull data from multiple tables in one SQL query using LINQ and Entity Framework (Core)

ZZZ_tmp

How to execute a raw union SQL query on several tables with Entity Framework Core

ZZZ_tmp

Getting {"error":"Null TypeMapping in Sql Tree"} from entity framework core using linq

ZZZ_tmp