Find/Delete and Update record MongoDB using C#

Question

This my doument

{ "_id" : ObjectId("57f65ed25ced690b5408a9d1"), "fbId" : "7854", "Name" : "user1", "pass" : "user1", "Watchtbl" : [ { "wid" : "745", "name" : "azs", "Symboles" : [ { "Name" : "nbv" } ] }, { "wid" : "8965", "name" : "bought stock1", "Symboles" : [ { "Name" : "AAA" }, { "Name" : "BSI" }, { "Name" : "EXXI" }, { "Name" : "AMD" } ] }, { "wid" : "9632", "name" : "bought stock3", "Symboles" : [ { "Name" : "AAA" }, { "Name" : "AMD" } ] } ] }

I want to find and update this record with a specific find, like I want to search by _id and wid and update the name and the Symboles of ths Watchtbl But it look _id and wid are not recognized when I try to do this filtre

var builder = Builders<BsonDocument>.Filter;
var filter = builder.Eq("_id", id) & builder.Eq("wid", wid);

it retrun 0.

So the idea is the same for Delete function

pieperu · Accepted Answer · 2016-10-14 14:05:51Z

1

You will want to use builder.And to join clauses for your filter

var filter = builder.And(builder.Eq("_id", id), builder.Eq("wid", wid))

For updating the individual fields, you can achieve this using the

Builders<BsonDocument>.Update.Set

I hope this helps

answered Oct 14, 2016 at 14:05

pieperu

2,7823 gold badges22 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Find/Delete and Update record MongoDB using C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related