Select multiple fields group by and sum

by

Updated :
If you’re trying to avoid grouping for all the fields, you can group just by Id:

data.GroupBy(d => d.Id)
    .Select(
        g => new
        {
            Key = g.Key,
            Value = g.Sum(s => s.Value),
            Name = g.First().Name,
            Category = g.First().Category 
        });

But this code assumes that for each Id, the same Name and Category apply. If so, you should consider normalizing as @Aron suggests. It would imply keeping Id and Value in one class and moving Name, Category (and whichever other fields would be the same for the same Id) to another class, while also having the Id for reference. The normalization process reduces data redundancy and dependency.

More Related Contents:

  1. How to display words that appear more than 'x' times in a text? [closed]
  2. Is there a good LINQ way to do a cartesian product?
  3. The result of a query cannot be enumerated more than once
  4. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  5. Cannot convert lambda expression to type ‘string’ because it is not a delegate type [duplicate]
  6. Find all child controls of specific type using Enumerable.OfType() or LINQ
  7. How to make LINQ execute a (SQL) LIKE range search
  8. The data source does not support server-side data paging
  9. Will using LINQ to SQL help prevent SQL injection
  10. How to convert DataTable to class Object?
  11. LINQ to SQL Where Clause Optional Criteria
  12. Create Dynamic Threads in c# [closed]
  13. Alphanumeric sorting using LINQ
  14. How to call code behind server method from a client side JavaScript function?
  15. XElement namespaces (How to?)
  16. Row_number over (Partition by xxx) in Linq?
  17. datetime.parse and making it work with a specific format
  18. Generate a PDF that automatically prints
  19. Why should I use int instead of a byte or short in C#
  20. Mutating the expression tree of a predicate to target another type
  21. How to return PDF to browser in MVC?
  22. Foreach loop, determine which is the last iteration of the loop
  23. Dynamic MySQL database connection for Entity Framework 6
  24. Create thumbnail image
  25. Encrypt cookies in ASP.NET
  26. How to recognize if a string contains unicode chars?
  27. Convert anonymous type to class
  28. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  29. ASP.Net Core MVC – Client-side validation for custom attribute
  30. LINQ to Entities does not recognize the method ‘System.String ToString()’ method in MVC 4

Leave a Comment