How to remove one 'document' by 'ID' using the Official C# Driver for MongoDB?

Question

Can someone please show me, if there is a better way to remove one document from MongoDB using the Official C# Driver than what I have below-

var query = Query.EQ("_id", a.Id);
database.GetCollection<Animal>("Animal").Remove(query);

This code works, but seems too much work to me. The "Save" command for example- takes an instance and updates it. I want something like- Remove(item).

Remarks: I'm trying to use the official driver of C# rather than NoRM or Samus which seems out of date.

score 35 · Accepted Answer · answered Jan 15 '12 at 02:39

35

That's the way you do it. I'm sure you know this, but if you want to put it on one line you could combine it so you don't need to define a query variable:

collection.Remove(Query.EQ("_id", a.Id));

answered Jan 15 '12 at 02:39

Eve Freeman

32,467
4
86
101

I'm trying to remove by a field other than _id, and I tried Query.EQ("FieldName", value) but it didn't work. How should I do that? Actually, your code gives the same error either : "only classes can be mapped currently." – Burak Karakuş Mar 04 '15 at 13:46
I just realized that I used a linq query, not the Query.EQ() above, and I guess that was the problem because it worked when I changed it to Query.EQ() query. Thanks for your help. – Burak Karakuş Mar 04 '15 at 17:56
5

This is not longer the answer, MongoDb Driver has changed significantly, this is no the correct answer: collection.DeleteOne(a => a.Id==id); – Brian Ogden Sep 12 '17 at 23:14

Minhas Kamal · Answer 2 · 2019-01-24T02:59:07.727

25

The Simplest Way

Remove a document from a collection for C# MongoDB Driver (v2.0 or later)-

collection.DeleteOne(a => a.Id==id);

Or-

await collection.DeleteOneAsync(a => a.Id==id);

edited Jan 24 '19 at 02:59

answered Feb 07 '16 at 07:52

Minhas Kamal

20,752
7
62
64

score 23 · Answer 3 · answered Jul 27 '14 at 21:35

23

If the [id] is string, you must use ObjectId instance explicitly.

var query = Query.EQ("_id", ObjectId.Parse(id));

answered Jul 27 '14 at 21:35

Ostati

4,623
3
44
48

I was having a problem that this answer fixes. Thanks. Upvoted. – ton.yeung Jul 31 '14 at 19:38

score 2 · Answer 4 · answered Nov 25 '17 at 11:27

My ASP.NET Core MVC controller's action accepts Id as a string parameter. Then I parse it and use the result in the DeleteOne() statement:

[HttpPost]
public IActionResult Delete(string id)
{
    ObjectId objectId = ObjectId.Parse(id);
    DbContext.Users.DeleteOne(x => x.Id == objectId);
    return null;
}

score 1 · Answer 5 · edited Oct 25 '20 at 21:39

1

var filter = Builders<BsonDocument>.Filter.Eq("_id",ObjectId.Parse(id));
var x = data.DeleteOne(filter);

I am using this with the current version ( in 2019 ), and it works.

edited Oct 25 '20 at 21:39

Paul Roub

36,322
27
84
93

answered Oct 25 '20 at 21:31

Eugen

21
4

score 0 · Answer 6 · answered Oct 04 '21 at 05:29

If you only want to delete a docuement from a collection :

public async Task<bool> Delete(string id)
{
    FilterDefinition<YourModel> filter = Builders<YourModel>.Filter.Eq(p => p.Id, id);

    var deleteResult = await _context.YourModelCollection.DeleteOneAsync(filter);

    return deleteResult.IsAcknowledged && deleteResult.DeletedCount > 0;
}

And if you want to delete all the docuements :

public async Task<bool> DeleteAll()
{
    FilterDefinition<YourModel> filter = Builders<YourModel>.Filter.Empty;

    var deleteResult = await _context.YourModelCollection.DeleteManyAsync(filter);

    return deleteResult.IsAcknowledged && deleteResult.DeletedCount > 0;
}

How to remove one 'document' by 'ID' using the Official C# Driver for MongoDB?

6 Answers6

The Simplest Way

Linked