Combine all the data in a class

Question

Hi everyone! If I had a class ReportInfo class ReportInfo { public String Name { get ; set ; } public Double Data { get ; set ; } } How can I make a List combine so that all the names that match add their data? for instance if i had a List that had Name=Sales Data=100; Name=Sales Data=100; Name=Sales Tax Data=100; Name=Sales Data=100; Name=Sales Tax Data=100; Name=Sales Data=100; How can I get a single list that would contain Name=Sales Data=400; Name=Sales Tax Data=200;

Vulpes · Answer

Here's one way to do it: using System; using System.Collections.Generic; class ReportInfo { public String Name { get; set; } public Double Data { get; set; } } class Program { static void Main() { var list = new List (); list.Add(new ReportInfo{Name = Sales Data = 100}); list.Add(new ReportInfo{Name = Sales Data = 100}); list.Add(new ReportInfo{Name = Sales Tax Data = 100}); list.Add(new ReportInfo{Name = Sales Data = 100}); list.Add(new ReportInfo{Name = Sales Tax Data = 100}); list.Add(new ReportInfo{Name = Sales Data = 100}); var dict = new Dictionary (); foreach(ReportInfo ri in list) { if(!dict.ContainsKey(ri.Name)) { dict.Add(ri.Name ri.Data); } else { dict[ri.Name] += ri.Data; } } var list2 = new List (); foreach(string key in dict.Keys) list2.Add(new ReportInfo{ Name = key Data = dict[key]}); // check it worked foreach(ReportInfo ri in list2) Console.WriteLine(Name = {0} Data = {1} ri.Name ri.Data); Console.ReadKey(); } }

patrick · Answer

This was excellent. Much more effective than my solution. Thank you.