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: https://stackoverflow.com/questions/49346654/c-sharp-mongodb-driver-how-to-use-updatedefinitionbuilder — Valentin, Apr 08 '22 at 12:37

score 5 · Accepted Answer · answered Aug 26 '16 at 09:34

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 });

mongodb C# Driver update multiple fields

1 Answers1