c# - Mongodb查询以获取特定于c#的嵌套文档的值

Question

以下是非结构化的示例 Bson 文档。由于我是 MongoDB 新手，因此尝试学习构建查询。
{

       "_id":ObjectId("562e7c594c12942f08fe4192"),
       "shapes":[  
          {  
             "shape":"square",
             "color":"blue"
          },
          {  
             "shape":"circle",
             "color":"red"
          }
       ]
    },
    {  
       "_id":ObjectId("562e7c594c12942f08fe4193"),
       "shapes":[  
          {  
             "shape":"square",
             "color":"black"
          },
          {  
             "shape":
                    {
                        "shape_s_time":""2020-06-29T12:00:14.3716902Z"
                         "shape__time":""2020-06-29T12:00:16.3716902Z"
                     },

             "color":"green"
          }
       ]
    }

我试过这段代码

var collection= db.GetCollection<BsonDocument>("Test");
var result = collection.Find(new BsonDocument()).Project(Builders<BsonDocument>.Projection.Include("shapes.shape.shape_s_time")).ToList();

但它给出了错误

有人可以告诉如何获得价值吗？

标签： c#.netmongodb-querymongodb-.net-driver

Answer 1

你有数据问题。上述两个文档示例可以正常工作。您的某些文档shapes.shape.shape_s_time格式似乎不同