c# - How do I update two object arrays in a single document using Mongo Driver

Question

How do I find and update the object arrays using the filters tasks.IsComplete == false and friends.IsBusy == false ? I want to match the first occurrence of the matching filter in each array object.

before document update

{ _id = 1, 
  "tasks": [{ "IsComplete": false }, { "IsComplete": false }],
  "friends": [{ "IsBusy": true,  }, { "IsBusy": false }] 
}

This isn't correct, but so far what I have.

     var filter = Builders<todo>.Filter.And(
                                Builders<todo>.Filter.Eq("_id", 1),
                                Builders<todo>.Filter.ElemMatch(x => x.tasks, x => x.IsComplete == false),
                                Builders<todo>.Filter.ElemMatch(x => x.friends, x => x.IsBusy == false)
                                );


            var update = Builders<todo>.Update.Combine(
            Builders<todo>.Update
            .Set(x => x.tasks[-1].IsComplete, true)
            .Set(x => x.friends[-1].IsBusy, true)
            );

    var result = await _context.todo.UpdateOneAsync(filter, update);

Expected Result

{ _id = 1, 
  "tasks": [{ "IsComplete": true}, { "IsComplete": false }],
  "friends": [{ "IsBusy": true,  }, { "IsBusy": true}] 
}

question from:https://stackoverflow.com/questions/65879379/how-do-i-update-two-object-arrays-in-a-single-document-using-mongo-driver

Answer 1

Waitting for answers