Remove document by id field in mongodb using C#

Question

I am trying to delete the document by id, which is of type ObjectId, I do have converted the string to ObjectId and passed as parameter to remove from collection, but I am not able to delete the record.

I don't know what is the actuall reason behind, Looking for solution, below is my code sample:

 public void DeleteRecords(string objectID)
        {
            try
            {
                // Create server settings to pass connection string, timeout, etc.
                MongoServerSettings settings = new MongoServerSettings();
                settings.Server = new MongoServerAddress("localhost", 27017);
                // Create server object to communicate with our server
                MongoServer server = new MongoServer(settings);

                MongoDatabase myDB = server.GetDatabase("DemoMongoDB");

                MongoCollection<BsonDocument> records = myDB.GetCollection<BsonDocument>("Records");
                //var query = Query<Records>.EQ(fd => fd._id, ObjectId.Parse(name));
                var query = Query<Records>.EQ(e => e._id, new BsonObjectId(objectID));
                records.Remove(query);

            }
            catch (Exception ex)
            {

            }
        }

The code works all good, without any exception, but document does not get deleted. — Systematix Infotech, Apr 09 '15 at 06:47
possible duplicate of [how to remove one document by Id using the official CSharp driver for Mongo](http://stackoverflow.com/questions/8867032/how-to-remove-one-document-by-id-using-the-official-csharp-driver-for-mongo) — Anton Putau, Sep 22 '15 at 23:53

Peyman · Answer 1 · 2015-04-09T07:29:59.713

3

Try below code, and see whether is working?

var query = Query.EQ("_id", new BsonObjectId("objectID"));

Or

var query = Query.EQ("_id", name);
records.Remove(query);

edited Apr 09 '15 at 07:29

answered Apr 09 '15 at 06:57

Peyman

3,068
1
18
32

This worked for me, without converting the string to object id, Thanks :) var query = Query.EQ("_id", name); records.Remove(query); – Systematix Infotech Apr 09 '15 at 07:26
Whats the name? is it your id – Peyman Apr 09 '15 at 07:27
Yes name is my objectId – Systematix Infotech Apr 09 '15 at 07:28

score 0 · Answer 2 · answered Apr 09 '15 at 07:36

0

Finally, This worked for me, without converting the string to object id and pass as a parameter as a string itself.

var query = Query.EQ("_id", objectID);
records.Remove(query);

answered Apr 09 '15 at 07:36

Systematix Infotech

2,345
1
14
31

Remove document by id field in mongodb using C#

2 Answers2