时间戳

首页 > 解决方案 > 使用 C# 获取和添加/更新多级嵌入式/嵌套 MongoDB 文档

c# - 使用 C# 获取和添加/更新多级嵌入式/嵌套 MongoDB 文档

问题描述

如何使用 C# 过滤和添加/更新 mongodb 文档的第三、第四级子级。我可以添加/更新到第二级，但不能更进一步。请为我提供解决方案或任何可以从哪里获得帮助的参考。除了builders..Elemmatch之外还有其他方法吗？

这是我的课程和代码：

namespace CrudWithMultilvelNestedDoc
{
    public class Channel
    {
        [BsonId]
        [BsonRepresentation(BsonType.String)]
        public string Id { get; set; }
        public string Name { get; set; }
        public Episode[] Episodes { get; set; }
    }

    public class Episode
    {
        [BsonId]
        [BsonRepresentation(BsonType.String)]
        public string Id { get; set; }
        public string Name { get; set; }
        public Track[] Tracks { get; set; }
    }

    public class Track
    {
        [BsonId]
        [BsonRepresentation(BsonType.String)]
        public string Id { get; set; }
        public string Name { get; set; }
        public Like[] Likes { get; set; }
    }

    public class Like
    {
        [BsonId]
        [BsonRepresentation(BsonType.String)]
        public string Id { get; set; }
        public string Name { get; set; }
    }
}

    //First Method
    //var filter = Builders<Channel>.Filter.And(Builders<Channel>
    //                              .Filter.Where(x => x.Id == "5e4606e6ae7b090688671416"), // OR &
    //             Builders<Channel>.Filter.ElemMatch(e => e.Episodes, Builders<Episode>
    //                              .Filter.Eq(e => e.Id, "5e460851d29c1b3df4d27b7d")));

    //Second Method
    //var filter = Builders<Channel>.Filter.Eq(e => e.Id, "5e4606e6ae7b090688671416") 
    //           & Builders<Channel>.Filter.ElemMatch(e => e.Episodes, Builders<Episode>.Filter.Eq(e => e.Id, "5e46071d385a672b0cea0f86"));

    //Third Method
    var filter = channelFilter.ElemMatch(e => e.Episodes, episodeFilter.ElemMatch(e=> e.Tracks, trackFilter.Eq(e => e.Id, "5e460dbe2bc5e70c9cfeac21")));
    var data = collection.Find(filter);         
    //Update Filter
    var update = Builders<Channel>.Update.Push("Episodes[-1].Tracks[-1].Likes", like);
    var result = collection.UpdateOne(filter, update);
//Data 
    {"_id":"5e4606e6ae7b090688671416","Name":"Channel 1","Episodes":[{"_id":"5e46071d385a672b0cea0f86","Name":"Episode 1","Tracks":[{"_id":"5e460dbe2bc5e70c9cfeac21","Name":"Trak 1","Likes":[]},{"_id":"5e4612d60747a2121870c815","Name":"Trak 2","Likes":[]}]},{"_id":"5e460851d29c1b3df4d27b7d","Name":"Episode 2","Tracks":[{"_id":"5e460e307ca6843758ce814e","Name":"Trak 1","Likes":[]}]}]}

在此处输入图像描述

标签： c#mongodblinqmongodb-.net-driver

解决方案

根据文档：

位置 $ 运算符不能用于遍历多个数组的查询

所以-1在这里使用不是一种前进的方式。您应该采用的方法是$ 位置过滤运算符。

C# 中没有强类型表示，因此您的代码如下所示：

var filter = Builders<Channel>.Filter.Eq(x => x.Id, "5e4606e6ae7b090688671416");

var like = new Like() {Name = "new like", Id = "1"};
var episodeId = "5e46071d385a672b0cea0f86";
var trackId = "5e460dbe2bc5e70c9cfeac21";

var update = Builders<Channel>.Update.Push("Episodes.$[e].Tracks.$[t].Likes", like);

var arrayFilters = new List<ArrayFilterDefinition>();
ArrayFilterDefinition<BsonDocument> episodesFilter = new BsonDocument("e._id", new BsonDocument("$eq", episodeId));
ArrayFilterDefinition<BsonDocument> tracksFilter = new BsonDocument("t._id", new BsonDocument("$eq", trackId));
arrayFilters.Add(episodesFilter);
arrayFilters.Add(tracksFilter);

var updateOptions = new UpdateOptions { ArrayFilters = arrayFilters };

var result = mongoDBCollection.UpdateOne(filter, update, updateOptions);

推荐阅读