LINQ聚合 [英] linq aggregate

问题描述

class Category
{        
    public string Name { get; set; }
    public int Count { get; set;}
}


Name Count
AA   2
BB   3
AA   4

我有一个IEnumerable<Category>

，并希望获得具有唯一名称和多个条目的总和的类别列表

and would like to get a list of Categories with unique names and the sum of multiple entries

输出

Name Count
AA   6
BB   3

更新

class Category 
{ 
public string Name { get; set; } 
public int CountA { get; set;} 
public int CountB { get; set;} 
public string Phone { get; set;} 
}

我如何对两列求和.并且电话"列可以是最后一行或任何一行

How would I sum two columns. and the phone column can be the last row or any row

推荐答案

var foo = new List<Category>() { 
                new Category() { Name = "AA", Count = 2},
                new Category() { Name = "BB", Count = 3},
                new Category() { Name = "AA", Count = 4}
            };

            var bar = foo.GroupBy(c => c.Name).Select(g => new Category(){ Name = g.Key, Count = g.Sum(c => c.Count) });

这篇关于LINQ聚合的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！