Can not delete document in db

[nikonarimanidze23 (ნიკო ნარიმანიძე)]

I can not delete document in db it deletes all data inside but empty document is still in db. How can not delete hole document ?

[steevej (Steeve Juneau)]

Please share how you did that.

[nikonarimanidze23 (ნიკო ნარიმანიძე)]

var client = new MongoClient(connectionString);
var database = client.GetDatabase(“SoftMasterDb”);

var collection = database.GetCollection(collectionName);

try
{
// Convert the string ID to ObjectId
var objectId = ObjectId.Parse(id);
//
var filter1 = Builders.Filter.Eq(item => item.Id, id);
await collection.DeleteManyAsync(filter1);
//await collection.DeleteOneAsync(filter1);

}
catch (Exception ex)
{
Console.WriteLine($“An error occurred: {ex.Message}”);
}

[steevej (Steeve Juneau)]

Many things.

It could be that if you have an

@nikonarimanidze23

empty document

it does not have a field named Id or id. I do not know the .net driver so I am not too sure. In particular, what is the value of item.Id?

If item.Id equals _id, then you probably have a type mismatch. It looks like you tried to avoid that with

@nikonarimanidze23

var objectId = ObjectId.Parse(id);

but you ignore this type conversion by querying with id in

@nikonarimanidze23

Builders.Filter.Eq(item => item.Id, id);

It could potentially work if you use the variable objectId rather than id.

[steevej (Steeve Juneau)]

@nikonarimanidze23, it has been more that a week since I took the time to read, think and reply to your post.

Please provide followup.

If my proposition worked, please mark my post as the solution. If it fails provide details about what did not work. If you found another solution please share.