MongoDB Query C# Driver

Question

I am having trouble with expressing this query in C# MongoDB, I want it to return all the results of an objectID where it does not equal to "000000000000000000000000" which works in MongoVue; But I can't get it work in my program.

{"ProfilePictureId" : {$ne: new ObjectId ("000000000000000000000000")}}

I am using official C# driver:

var query = new QueryDocument();
foreach (BsonDocument book in col.Find(query))
{
    ...
}

shA.t · Accepted Answer · 2015-09-13 04:50:31Z

8

You can build your query as follows:

var query = Query.NE("ProfilePictureId", ObjectId.Empty);

ObjectId.Empty returns an ObjectId composed of all zeroes.

edited Sep 13, 2015 at 4:50

shA.t

17k5 gold badges59 silver badges121 bronze badges

answered Feb 13, 2012 at 1:25

Brian Knight

5,04130 silver badges34 bronze badges

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

Comments

malla · Accepted Answer · 2016-06-17 07:11:18Z

0

Assuming that you are querying for documents of a class looking something like:

public class Profile {
        public ObjectId ProfilePictureId { get; set; }
        //... other attributes, construcotrs, methods etc...
}

You can also write your query using expression lambdas like this:

var query = Query<Profile>.NE(s => s.ProfilePictureId, ObjectId.Empty);

answered Jun 17, 2016 at 7:11

malla

1,7182 gold badges17 silver badges25 bronze badges

Collectives™ on Stack Overflow

MongoDB Query C# Driver

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related