使用 groupby 将数据分组后,在每组内部调用 count 并传入布尔条件表达式即可统计。具体做法是先按目标字段分组,再对每个组执行 g.count(x => x.condition),这会返回该组中满足条件的元素数量。

如何获取每组的计数结果并映射到对象?
通过 Select 投影可以将分组后的键和计数值组合成匿名对象或自定义结构。代码演示了如何从列表中提取数据,按类别分组,并计算每类中状态为真的项目数,最终输出包含类别名和计数的结果集。

using System;
using System.Collections.Generic;
using System.Linq;
public class Item
{
public string Category { get; set; }
public bool IsActive { get; set; }
}
public class Program
{
public static void Main()
{
var items = new List<item>
{
new Item { Category = "A", IsActive = true },
new Item { Category = "A", IsActive = false },
new Item { Category = "A", IsActive = true },
new Item { Category = "B", IsActive = true },
new Item { Category = "B", IsActive = false },
new Item { Category = "B", IsActive = false }
};
var result = items
.GroupBy(i => i.Category)
.Select(g => new
{
Category = g.Key,
TrueCount = g.Count(x => x.IsActive)
})
.ToList();
foreach (var r in result)
{
Console.WriteLine($"Category: {r.Category}, Count: {r.TrueCount}");
}
}
}</item>
如果分组键为 null 会怎样处理?
当分组键(Key)为 null 时,GroupBy 会将所有键为 null 的元素归入同一个组,该组的 Key 属性值为 null。在统计时,这些元素会被正常计入该组的总数中,不会抛出异常。若需排除空值分组,可在分组前添加 Where 过滤条件。

using System;
using System.Collections.Generic;
using System.Linq;
public class DataRecord
{
public string GroupId { get; set; }
public bool IsComplete { get; set; }
}
public class Program
{
public static void Main()
{
var records = new List<datarecord>
{
new DataRecord { GroupId = "G1", IsComplete = true },
new DataRecord { GroupId = null, IsComplete = true },
new DataRecord { GroupId = null, IsComplete = false },
new DataRecord { GroupId = "G2", IsComplete = true }
};
// 包含 null 键的分组统计
var withNulls = records
.GroupBy(r => r.GroupId)
.Select(g => new
{
Key = g.Key ?? "NULL_KEY",
CompleteCount = g.Count(x => x.IsComplete)
});
foreach (var item in withNulls)
{
Console.WriteLine($"Key: {item.Key}, Count: {item.CompleteCount}");
}
}
}</datarecord>











