Removing a document from array of documents in mongodb using c#

Question

I want to remove the highest value price document

{
    "name" : "Ryan",
    "price" : 6.5
}

from

db.books.find({_id:5}).pretty()
{
    "_id" : 5,
    "name" : "Big Book",
    "authors" : [
        {
            "name" : "Ryan",
            "price" : 5.5
        },
        {
            "name" : "Ryan",
            "price" : 6.5
        }
    ]
}

using c# driver

I have the removable document in c# front end in a collection.

But my following update statement is not removing the document.

var filter = new BsonDocument("_id", x._id);
var docToRemove = new BsonDocument("name", x.name);docToRemove.Add("price", x.price);
var update = Builders<Book>.Update.Pull("books.authors", docToRemove);
var result = await col.FindOneAndUpdateAsync(filter, update);

marcinax · Accepted Answer · 2015-11-02 18:45:02Z

2

Do you have required value in x.price?

I didn't test it for exactly your case, but try this:

var update = Builders<Book>.Update.PullFilter(p => p.authors,
                                              f => f.price == x.price);
var result = await collection.FindOneAndUpdateAsync(p => p._id == 5, update);

answered Nov 2, 2015 at 18:45

marcinax

1,20510 silver badges11 bronze badges

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

1 Comment

Naresh Over a year ago

Cool sir, this one works. Thank you. In my case, as I needed to add 1 more condition to check along with price, I had to add an &&. So finally my update looks like this. var update = Builders<Book>.Update.PullFilter(p => p.authors, f => (f.price == x.price && f.author == x.author ));

Collectives™ on Stack Overflow

Removing a document from array of documents in mongodb using c#

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