Not equal to operator for MongoDB query in C#

Question

I have one query in MongoDB like below,

db.getCollection('Student')
.find({_id: 123, $where:"this.section != this.upperSection"})

How to convert this query to execute from C# code?

I tried using the below code but that didn't work. Can you guide me?

var builder = Builders<BsonDocument>.Filter;

var filter = builder.Not("section ", "upperSection");

Sample Mongo docs - & the expected outcome should be doc2

//doc1
{
    "_id" : "123",
    "section" : "X",
    "upperSection" : "X"
}

//doc2
{
    "_id" : "123",
    "section" : "X",
    "upperSection" : "Y"
}

Yong Shun · Accepted Answer · 2022-02-24 08:20:38Z

1

You can apply the query as BsonDocument.

FilterDefinition<BsonDocument> filter = new BsonDocument("$expr", 
    new BsonDocument("$ne",
        new BsonArray { "$section", "$upperSection" }
    )
);

Output

answered Feb 24, 2022 at 8:20

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

Not equal to operator for MongoDB query in 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