GroupBy in EF Core 3.1 / EF Core 5.0 not working, even for the simplest example
Earlier EF/EF core automatically converted to client-side query evaluation when server-side evaluation was not possible. Grouping by a key without select is not something supported by SQL and would always have been a client-side operation. With EF 3.0+, they made it explicit on which query should run on server or on client. Technically it is … Read more