How to Execute Select Count and Group Query 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 quantity or number of items.

//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) });