no

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...

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

Related

.net 7257518787782276945

Post a Comment

item