How to execute select count(*), field from table group by field in entity framework
As the title implies we will try to convert a native sql that group and counts the number of row. We will assume that you have a column qua...

//native query select count(*), field from table group by field //entity framework var query = model.GroupBy(p => p.Field).Select(o => new { o.Key, Count = o.Sum(p => p.Quantity) });
Post a Comment