How can I use LINQ for aggregation in ASP.NET Core?

How can I use LINQ for aggregation in ASP.NET Core?

You can use LINQ's aggregation methods like Sum, Count, Average, Min, and Max to perform calculations on data collections.

Can you give me an example of using Sum with a list of products?

Sure! If you have a list of products, you can use: var totalPrice = products.Sum(p => p.Price); to get the total price.

What if I want to group the products by category before summing?

You can use GroupBy like this: var groupedTotal = products.GroupBy(p => p.Category).Select(g => new { Category = g.Key, TotalPrice = g.Sum(p => p.Price) });.

Is there a way to count the number of products in each category?

Yes! You can modify the previous example to count instead: var categoryCounts = products.GroupBy(p => p.Category).Select(g => new { Category = g.Key, Count = g.Count() });.