C# Linq Group By on multiple columns [duplicate]

by 
var consolidatedChildren =
    from c in children
    group c by new
    {
        c.School,
        c.Friend,
        c.FavoriteColor,
    } into gcs
    select new ConsolidatedChild()
    {
        School = gcs.Key.School,
        Friend = gcs.Key.Friend,
        FavoriteColor = gcs.Key.FavoriteColor,
        Children = gcs.ToList(),
    };

var consolidatedChildren =
    children
        .GroupBy(c => new
        {
            c.School,
            c.Friend,
            c.FavoriteColor,
        })
        .Select(gcs => new ConsolidatedChild()
        {
            School = gcs.Key.School,
            Friend = gcs.Key.Friend,
            FavoriteColor = gcs.Key.FavoriteColor,
            Children = gcs.ToList(),
        });

More Related Contents:

  1. Group By Multiple Columns
  2. Group by in LINQ
  3. LINQ with groupby and count
  4. LINQ Aggregate algorithm explained
  5. LINQ Grouping dynamically
  6. Client side GroupBy is not supported
  7. LINQ: combining join and group by
  8. Linq order by, group by and order by each group?
  9. LINQ Group By Multiple fields -Syntax help
  10. ILookup vs. IGrouping
  11. Linq to Objects – return pairs of numbers from list of numbers
  12. linq distinct or group by multiple properties
  13. Group by variable integer range using Linq
  14. LINQ to Entities group-by failure using .date
  15. Return anonymous type results?
  16. Why doesn’t Include have any effect?
  17. Directory.GetFiles of certain extension
  18. Async await in linq select
  19. Why is LINQ .Where(predicate).First() faster than .First(predicate)?
  20. MVC 4 how pass data correctly from controller to view
  21. How to take all but the last element in a sequence using LINQ?
  22. LINQ identity function
  23. LINQ Expression to return Property value?
  24. Remove duplicate items from list in C#, according to one of their properties
  25. Check if list contains item from other list in EntityFramework
  26. Entity Framework core – Contains is case sensitive or case insensitive?
  27. How to do an “in” query in entity framework?
  28. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  29. C# Searching for files and folders except in certain folders
  30. What is the difference between LINQ ToDictionary and ToLookup

Leave a Comment