How to build a query with MongoDB?

Question

I need to have a query as such

Query.And(Query.NE("name", name[0]), Query.NE("name", name[1]));

However I don't know the number of elements in name[] and I need to make a AND of NE of all elements of name[].

Is there a way to build it?

what tool are you using? (What/where is Query coming from?) I'd expect you'd find your answer by searching a little more. Here's a random cheat sheet layerworks.com/blog/2014/11/11/… — Don Cheadle
– Don Cheadle, Commented Aug 12, 2016 at 14:16
thanks for your answer. I'm using MongoDB.Driver.Builders.Query — Maxime Joyal
– Maxime Joyal, Commented Aug 12, 2016 at 14:26
You likely want to be using $nin here instead; that way you don't have to build your query dynamically and it will be more efficient. — JohnnyHK
– JohnnyHK, Commented Aug 12, 2016 at 14:33

toadflakz · Accepted Answer · 2016-08-12 14:32:50Z

1

The Query.AND() method signature takes IEnumerable<IMongoQuery> parameter type so you could write your method as follows for any number of items:

Query.AND(name.Select( x=> Query.NE("name", x));

answered Aug 12, 2016 at 14:32

toadflakz

7,9441 gold badge29 silver badges41 bronze badges

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

1 Answer 1