How to write update query to update multiple fields in mongodb?

Question

How to write this update query for updating a mongo record in c#.

db.collection.update({ "S_Id" : 110 },{ "Name" : "Name1","Batch" : "43","Date":"9/2/2011",  "Status" : 0 });

I'am trying like this

IMongoUpdate update = new UpdateDocument();
if (Named != null) { update = Update.Set("Name", "Name1"); }
if (Date != null) { update = Update.Set("Date", "18/02/2013"); }
if (Batch != null) { update = Update.Set("Batch",43); }
coll.Update(query, update);

was I'am doing correct or in what way i have to do it, please make me the correct way to proceed.

Kevin Versfeld · Accepted Answer · 2013-02-18 13:43:38Z

14

In your example, you are potentially overwriting the value of update for each option, so will only be sending a single update command to col1.Update().

you will want to use the Update.Combine method, something vaguely like this: (untested, and a bit ugly...)

    var updateValues = new List<UpdateBuilder>();
    if (Named != null) { updateValues.Add(Update.Set("Name", "Name1")); }
    if (Date != null) { updateValues.Add(Update.Set("Date", "18/02/2013")); }
    if (Batch != null) { updateValues.Add(Update.Set("Batch", 43)); }
    IMongoUpdate update = Update.Combine(updateValues);
    coll.Update(query, update);

answered Feb 18, 2013 at 13:43

Kevin Versfeld

7305 silver badges18 bronze badges

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

Comments

Shantanu Pandey · Accepted Answer · 2016-07-10 10:27:12Z

0

it has now modified to:

    FilterDefinitionBuilder<BsonDocument> builder = Builders<BsonDocument>.Filter;
    FilterDefinition<BsonDocument> filter;

    filter = builder.Eq("_id",BsonObjectId.Create(objectid));

// or field to search

    var update = Builders<BsonDocument>.Update
 .Set("key1", "value1")
 .Set("key2", "value2")
 .CurrentDate("lastModified"); 

  Collection.UpdateOne(filter, update);

answered Jul 10, 2016 at 10:27

Shantanu Pandey

693 bronze badges

1 Comment

Jeppe Over a year ago

This does not apply as the question specifically is about building an update over multiple lines. Your query works, it just does not answer the question.

Collectives™ on Stack Overflow

How to write update query to update multiple fields in mongodb?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related