This is due to one of the breaking changes in EF Core 3.0 and that is: LINQ queries are no longer evaluated on the client
So write the query in such way that EF Core can convert the expression into T-SQL or fetch the data into memory and then make your query.