Entity Framework 7 group by

Question

I'm trying to run the following code but when I check the SQL profiler it looks like it runs a full select on the table and then does the grouping after it returns all results from the database. Any help is appreciated.

 var result = _dbContext.LogEvent.GroupBy(x => x.EventLevel)
                                 .Select(g => new 
                                              { 
                                                  eventType = g.Key, 
                                                  total = g.Sum(i => i.Occurrences) 
                                              }) 
                                 .ToList();

Answer 1

Updated:

The issue linked below has been closed, and it is slated for EF 2.1.0. You should be able to try it out now using the Preview package!

---

Original answer:

It doesn't look like this is currently supported, but it looks like someone saw this post and created the linked issue.

The concept is a fairly complex bit of logic, and EF7 is very much in an early phase. .Net's GroupBy doesn't translate directly to SQL's GROUP BY until you follow it up with only aggregates or the Key in a Select. If you're feeling ambitious, you could work on providing a pull request, or continue to use EF6.