c# - 我如何将此 mongodb 查询转换为 c# 驱动程序？

Question

我如何为此编写兼容的 C# 代码？

我知道我可以像这样进行投影:

var projection = Builders<BsonDocument>.Projection.Include("title");

但不知道如何在查找聚合后投影姓氏以获取作者的姓氏

db.books.aggregate(
   [
      {
         $project: {
            title: 1,
            lastName: "$author.lastName",
         }
      }
   ]
)

Answer 1

试试这个

            var project = new BsonDocument
            {
                {
                    "$project",
                    new BsonDocument
                    {
                        {"title", 1},
                        {"lastName", "$author.lastName"},
                    }
                }
            };

            var pipelineLast = new[] { project };


            var resultLast = db.books.Aggregate<BsonDocument>(pipelineLast);
            var matchingExamples = await resultLast.ToListAsync();
            foreach (var example in matchingExamples)
            {
// Display the result 
            }