How is this SQL statement done with Entity Framework? SUM column in Entity Framework

Viewed 51

This is my table:

https://i.stack.imgur.com/URpEI.png

How is this SQL statement done with Entity Framework:

https://i.stack.imgur.com/IiqTs.png

I appreciate any help

1 Answers

Method Syntax:

var result = yourTable.GroupBy(i => i.ProductoId)
                           .Select(g => (g.Key,g.Sum(ing => ing.SumaUnidadesIngresados))

Query syntax:

var result = from i in ingresosStock
             group i by i.ProductoId into gr
             select (gr.Key, gr.Sum(s => s.SumaUnidadesIngresados))
Related