Mongodb C# driver update array element

Question

I can't seem to figure out the exact set of statements that are needed to update an entire element of an array. This is what I have currently:

//id, gameId, updatedGame passed in
var client = mongoContext.Clients.FindOne( Query<Client>.EQ(x => x.Id, id));
var index = client.Games.FindIndex(x => x.Id == gamedId);
var update = Update<Client>.Set(x => x.Games[index], updatedGame);
var query = Query<Client>.EQ(x => x.Id, client.Id);
mongoContext.Clients.Update(query, update);
mongoContext.Clients.Save(client);

I can do this in javascript, but unfortunately I'm working in C# at the moment. Thanks for any help.

What error are you getting?

alstonp
– alstonp

2014-08-19 03:10:58 +00:00
Commented Aug 19, 2014 at 3:10 — alstonp
– alstonp, Commented Aug 19, 2014 at 3:10
I was not getting any error. It just silently failed.

sanjosep43
– sanjosep43

2014-08-19 23:18:10 +00:00
Commented Aug 19, 2014 at 23:18 — sanjosep43
– sanjosep43, Commented Aug 19, 2014 at 23:18

alstonp · Accepted Answer · 2014-08-19 03:39:12Z

1

The Update() statement you are using is more suited for bulk updates. In this case you only need to update one record so all you need is the Save() function. Also, without knowing the code behind mongoContext there are only certain things we can help with. Your object looks like it was adopted as a mixture between EF Code First and the mongo syntax. Anyway, here is how I've accomplished something very simular:

MongoCollection<Reported> collection = GetCollection();
Reported report = collection.FindOneById(Id);
report.IsReviewed = true;
collection.Save(report);

By using the FindOneById() function mongo returns a copy of your object with it's ObjectId. Which means all subsequent changes to that object will be updated when you pass it back to the Save() function. In your case, changing your array value would be done in where I set report.IsReviewed = true;

answered Aug 19, 2014 at 3:39

alstonp

7006 silver badges26 bronze badges

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

1 Comment

sanjosep43 Over a year ago

That did work. I just updated the actual array element.

Collectives™ on Stack Overflow

Mongodb C# driver update array element

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related