7

I need to update a field of one element from array sub document of a document.

MongoDB have the $ positional operator to do this. But in MongoDB C# driver version 2 it seems that there is no support for this operator.

How can I achieve this?

Documents:

{ "_id" : 1, "grades" : [ 80, 85, 90 ] }
{ "_id" : 2, "grades" : [ 88, 90, 92 ] }
{ "_id" : 3, "grades" : [ 85, 100, 90 ] }

Expected query:

db.students.update(
     { _id: 1, grades: 80 },
     { $set: { "grades.$" : 82 } }
   )
farid bekran
  • 2,684
  • 2
  • 16
  • 29

1 Answers1

14

You can try something like this.

var builder = Builders<Student>.Filter;
var filter = builder.Eq(student=> student.Id, 1) & builder.ElemMatch(student => student.Grades, x => x == 80);

var builder = Builders<Student>.Update;
var update = builder.Set(student => student.Grades[-1], 82);

var result = collection.UpdateOne(filter, update);
Noldorin
  • 144,213
  • 56
  • 264
  • 302
s7vr
  • 73,656
  • 11
  • 106
  • 127