Linq查询汇总按列排序

本文关键字：排序 查询 Linq | 更新日期: 2023-09-27 18:09:36

场景是这样的

public class Test {
   public string name;
   public int val1;
    public int val1;
}
name |val 1 |val 2|
'aa' | 10   | 4   | 
'aa' | 30   | 5   | 
'bb' | 14   | 4   |
'bb' | 16   | 6   | 
'cc' | 5    | 5   |
'cc' | 2    | 1   |
'cc' | 1    | 1   |

按名称分组并获得每个名称的汇总val_1和val_2的最佳方法是什么

name |val 1 |val 2|
'aa' | 40   | 9   | 
'bb' | 30   | 10  | 
'cc' | 8    |  7  |

Linq查询汇总按列排序

试试这个

var results =
    from t in db.Tests
    group t by t.name into g
    orderby g.Key
    select new
    {
        name = g.Key,
        val_1 = g.Sum(x => x.val_1),
        val_2 = g.Sum(x => x.val_2)
    };

或者如果你喜欢流畅的语法:

var results = db.Tests.GroupBy(t => t.name)
                      .OrderBy(g => g.Key)
                      .Select(g => new
                              {
                                  name = g.Key,
                                  val_1 = g.Sum(x => x.val_1),
                                  val_2 = g.Sum(x => x.val_2)
                              });
相关文章：