Update a nested Array in Mongo with c#

Question

I have a document like this

{
"_id": "63dafa72f21d48312d8ca405",
"tasks": [{
    "_ref": "63d8d8d01beb0b606314e322",
    "data": {
        "values": [{
            "key": "Deadline",
            "value": "2014-10-13"
        }]
    }
}, {
    "_ref": "84dd046c6695e32322d842f5",
    "data": {
        "values": []
    }
}]
}

Now I want to update the value inside values which is inside data if the _ref field do match my input.

My code so far:

public bool updateProject(Project dbPro, Project pro)
{
    var collection = db.GetCollection<BsonDocument>("projects");
    var filter = Builders<BsonDocument>.Filter.Eq("_id", ObjectId.Parse( dbPro.Id));
    var update = Builders<BsonDocument>.Update.AddToSetEach("tasks", pro.Tasks);
    var result = collection.UpdateOne(filter, update);
    if (result.IsModifiedCountAvailable)
    {
        if (result.ModifiedCount == 1)
        {
            return true;
         }
    }
    return false;
}

At the moment this code does only append the documents as new tasks instead to append the values to the matching tasks. Maybe someone has an idea how to achieve this behavior?

UPDATE

I tried it like @Shane Oborn said. But its still not working for me.

            var collection = db.GetCollection<BsonDocument>("projects");
        var filter = Builders<BsonDocument>.Filter.Eq("_id", ObjectId.Parse( dbPro.Id));
        var update = Builders<BsonDocument>.Update.Push("tags", buildBsonArrayFromTags(pro.Tags));
        var result = collection.UpdateOne(filter, update);
        if (result.IsModifiedCountAvailable)
        {
            if (result.ModifiedCount == 1)
            {
                return true;
            }

        }


        return false;
    }

Instead to override the data it appends an array to my array.

UPDATE

OK instead of push i did need set. And it worked then.

Take a look at this question, It could help you.

Facundo La Rocca
– Facundo La Rocca

2017-01-19 13:50:33 +00:00
Commented Jan 19, 2017 at 13:50 — Facundo La Rocca
– Facundo La Rocca, Commented Jan 19, 2017 at 13:50
Thanks. I will try it.

Kleisophabo
– Kleisophabo

2017-01-19 13:57:54 +00:00
Commented Jan 19, 2017 at 13:57 — Kleisophabo
– Kleisophabo, Commented Jan 19, 2017 at 13:57

Shane Oborn · Accepted Answer · 2017-01-19 14:03:01Z

2

I don't have the exact code accessible, but close. I have a method that performs "upserts" (which "adds" if new, or "updates" if existing). This should get you close:

// The variable "doc" below is a BsonDocument

var updateRequests = new List<WriteModel<BsonDocument>>();
updateRequests.Add(new ReplaceOneModel<BsonDocument>(
    CreateBsonDocumentFilterDefinition(filterKeyName, filterKeyValue), doc)
    {
        IsUpsert = true
    });
var writeResult = await collection.BulkWriteAsync(updateRequests);

The key objects here for you are "ReplaceOneModel" and the "IsUpsert" property for the filter definition.

Good luck!

UPDATE:

Another method I have that does updates in subdocuments looks like this:

// Below, "subDocument" is a BsonDocument, and "subDocArrayName" is a string
// that should match the name of the array that contains your sub-document
// that will be updated.

var collection = _database.GetCollection<BsonDocument>(collectionName);

var builder = Builders<BsonDocument>.Update;
var update = builder.Push(subDocArrayName, subDocument);

await collection.UpdateOneAsync(CreateBsonDocumentFilterDefinition(filterKeyName, filterKeyValue), update);

edited Jan 19, 2017 at 14:03

answered Jan 19, 2017 at 13:58

Shane Oborn

2281 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kleisophabo Over a year ago

I will give this a try too. Thanks for the fast help.

Kleisophabo Over a year ago

I tried your methods but it didn't work. I updated my post

Kleisophabo Over a year ago

OK i figured it now. Instead of push i used set. And it worked

Collectives™ on Stack Overflow

Update a nested Array in Mongo with c#

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related