mongodb C# Driver update multiple fields

Question

I have a dictionary that I'd like to use to update a mongodb record. I'm using a simple foreach to iterate the dictionary and construct an UpdateDefinition object. The problem is that I can't initialize an empty UpdateDefinition object, and therefore am forced into initializing the UpdateDefinition with an existing key value:

IDictionary<string, object> document = GetDocument();
string firstKey = document.Keys.First();
var update = Builders<BsonDocument>.Update.Set(firstKey, document[firstKey]);

foreach (var key in document.Keys)
{
    update = update.Set(key, document[key]);
}

This is horrible. FilterDefinition has an empty Filter which works great for this purpose. Is there anything similar for building iterative UpdateDefinitions?

I think a similar question has the right answer for this as well: stackoverflow.com/questions/49346654/… — Valentin
– Valentin, Commented Apr 8, 2022 at 12:37

andrei.ciprian · Accepted Answer · 2016-08-26 09:34:32Z

5

Using clues:

BsonDocument has a constructor with a Dictionary parameter
There's an implicit conversion from BsonDocument to UpdateDefinition
There's an implicit conversion from BsonDocument to FilterDefinition

you can do reduce everything to this one liner, (upsert not mandatory):

// IDictionary<string, object> dict = ...;
collection.UpdateOne(new BsonDocument("_id", "some_filter"), new BsonDocument("$set", new BsonDocument(dict)), new UpdateOptions { IsUpsert = true });

answered Aug 26, 2016 at 9:34

andrei.ciprian

3,0451 gold badge21 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

mongodb C# Driver update multiple fields

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related