How to use multiple filters in a MongoDb find query using C#

Question

I have this query which works fine in datagrip

test> db.getCollection("comments").find({status: {$ne: "APPROVED"},storyID: {$regex: "bbjfn-*"}})

I'm just wondering how to achieve the same thing in C# using the MongoDB Driver 2.13.1

IMongoDatabase database = MongoClient.GetDatabase(Program.Settings.MongoDB.Database);
IMongoCollection<BsonDocument> collection = database.GetCollection<BsonDocument>("comments");

var filter = Builders<BsonDocument>.Filter.Eq("status", new BsonDocument("$ne", "APPROVED")) & 
Builders<BsonDocument>.Filter.Eq("storyID", new BsonDocument("$regex", "bbjfnfn-*"));

var results = await collection.FindAsync(filter);

Doesn't work.. what am I doing wrong?

Yong Shun · Accepted Answer · 2021-10-13 23:25:37Z

5

You can set filter with BsonDocument object as below:

FilterDefinition<Store> filter = new BsonDocument
{
    { "status", new BsonDocument("$ne", "APPROVED") }, 
    { "storyID", new BsonDocument("$regex", "bbjfn-*") }
};

OR

var builder = Builders<BsonDocument>.Filter;
var filter = builder.Ne("status", "APPROVED") & builder.Regex("storyID", "bbjfn-*");

FYI, you can use MongoDB Compass to export Query to C# Language.

edited Oct 13, 2021 at 23:25

answered Oct 13, 2021 at 11:46

Yong Shun

54.6k6 gold badges38 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

How to use multiple filters in a MongoDb find query 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