Tim Feldmann
Tim Feldmann
In the same boat as everyone else. I want to add the same exact error occurs when adding $order OR $top. I did find that you need to return IQueryable...
I am also running into this exact issue and spent the past 5 hours trying to find a workaround with no success.
Using your sample: ```csharp var results = await _dbContext.Crashes .GroupBy( v => new {v.Name, v.Color, v.Make }, // Retrieve only the latest crash per Name / Color / Make group....
Yeah, I completely sympathize with the EF team, however a "catch all" solution for manually appending SQL to the end of an `IQueryable` would be great as a short /...
Thank you @roji, it's very much appreciated! Regarding the workarounds, I spent a few hours trying to use SQL + LINQ composition, however I was looking for a way to...