linq-group - w3toppers.com

Select multiple fields group by and sum

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. … Read more

Use LINQ to concatenate multiple rows into single row (CSV property)

That’s the GroupBy operator. Are you using LINQ to Objects? Here’s an example: using System; using System.Collections.Generic; using System.Linq; public class Test { static void Main() { var users = new[] { new { User=”Bob”, Hobby=”Football” }, new { User=”Bob”, Hobby=”Golf” }, new { User=”Bob”, Hobby=”Tennis” }, new { User=”Sue”, Hobby=”Sleeping” }, new { User=”Sue”, … Read more