Grouping in linq

Question

I have a following list of documents:

List<DocumentInfo> list1 = new List<DocumentInfo>()
{
   new DocumentInfo { Name = "Customer1", DocCount = 5 },
   new DocumentInfo { Name = "Customer1", DocCount = 10 },
   new DocumentInfo { Name = "Customer1", DocCount = 5 },
   new DocumentInfo { Name = "Customer2", DocCount = 4 },
   new DocumentInfo { Name = "Customer2", DocCount = 6 },
   new DocumentInfo { Name = "Customer3", DocCount = 3 }
};

How to group the above list based on 'Name' and sum of 'DocCount' using Linq and store in another list? I want something like following:

Name = "Customer1", DocCount = 20
Name = "Customer2", DocCount = 10
Name = "Customer3", DocCount = 3

MarcinJuraszek · Accepted Answer · 2013-03-08T07:56:22.973

4

var results = list1.GroupBy(i => i.Name)
                   .Select(g => new
                                {
                                    Name = g.Key,
                                    DocCount = g.Sum(i => i.DocCount)
                                });

edited Mar 08 '13 at 07:56

answered Mar 08 '13 at 07:55

MarcinJuraszek

124,003
15
196
263

score 1 · Answer 2 · answered Mar 08 '13 at 07:56

var list2 = list1.GroupBy(x => x.Name).Select(g => new DocumentInfo()
                                      {
                                          Name = g.Key,
                                          DocCount = g.Sum(x => x.DocCount)
                                      });

score 1 · Answer 3 · answered Mar 08 '13 at 07:56

1

Try this:

list1.GroupBy(di => di.Name).Select(g => new DocumentInfo {Name = g.Key, DocCount = g.Sum(dc => dc.DocCount)});

answered Mar 08 '13 at 07:56

aush

2,108
1
14
24

Soner Gönül · Answer 4 · 2013-03-08T08:03:48.390

0

Try like this;

var anotherlist = list1.GroupBy(g => g.Name)
                  .Select(s => new
                  {
                      Name = s.Key,
                      DocCount = s.Sum(i => i.DocCount)
                  });

It is simply, getting sum of DocCount and their Name properties by grouping based Name.

edited Mar 08 '13 at 08:03

answered Mar 08 '13 at 07:57

Soner Gönül

97,193
102
206
364

score 0 · Answer 5 · answered Mar 08 '13 at 08:00

0

var result= from item in list1
            group item by item.Name
            into g
            select g;
var groupedInfo = result.SelectMany(group => group);
foreach(var g in groupedInfo)
{
     //Do Summation
}

answered Mar 08 '13 at 08:00

David

15,894
22
55
66

score 0 · Answer 6 · answered Aug 02 '13 at 01:48

0

Here is another way to do the same

var sumOfDocs = from doc in list1 group doc by doc.Name into g 
                select new { DocName = g.Key, DocSum = g.Sum(i => i.DocCount) };

answered Aug 02 '13 at 01:48

Sriwantha Attanayake

7,694
5
42
44

Grouping in linq

6 Answers6