c# - 在monodb c#驱动程序中使用聚合函数显示类别项目及其计数

Question

//聚合函数列出RAGStatus类别和计数

//预期输出 R 7 G 1

//列表活动的类

**public class RagStatusCount
    {
        public string RagStatus { get; set; }
        public int Count { get; set; }
    }**

//聚合函数

var outboudTracesCount = mongoDBContext.GetMongoDbCollection().Aggregate() .Match(filterOutbound) .Group( r => r.RAGStatus, g => new RagStatusCount { RagStatus = g.Distinct().Select(x => x.RAGStatus) .FirstOrDefault(), Count = g.Count(), } ).ToEnumerable();

//回复

**{
  "outboudTracesCount": [
    {
      "ragStatus": [
        "R",
        "R",
        "R",
        "R",
        "R",
        "R",
        "R"
      ],
      "count": 7
    },
    {
      "ragStatus": [
        "G"
      ],
      "count": 1
    }
  ],
  "id": null,
  "extraElements": null
}**

标签： c#mongodbaggregate