C# mongodb where OR List<string>

Question

My document has a property that is of the type List<string>. I want to return all documents from a collection where a set of strings match any item from this List<string> property.

I would like to construct this like the following question, but in C#:

MongoDB find where key equals string from array

I know this is off, but it's my best attempt:

var queryItems = new List<QueryComplete>();
queryItems.Add(Query.EQ("PropertyName", "test"));
var query= Query.Or(queryItems.ToArray());
var qd = new QueryDocument(new BsonDocument { query.ToBsonDocument() });
var result = GetCollection<CollectionName>().FindAs<Type>(qd)

Asya Kamsky · Accepted Answer · 2012-07-25 07:06:23Z

1

Looks like what you are looking for is described here:

ContainsAny

This method is used to test whether an array (or array-like) field or property contains any of the provided values.

var query =
    from c in collection.AsQueryable<C>()
    where c.A.ContainsAny(new[] { 1, 2, 3 })
    select c;
// or
var query =
    collection.AsQueryable<C>()
    .Where(c => c.A.ContainsAny(new[] { 1, 2, 3 }));

answered Jul 25, 2012 at 7:06

Asya Kamsky

42.4k5 gold badges113 silver badges133 bronze badges

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

1 Comment

user376456 Over a year ago

yes ContainsAny works perfectly. I see that in the docs now. Thanks

Robert Stam · Accepted Answer · 2012-07-25 15:37:59Z

1

If for some reason you prefer not to use LINQ, you can use the query builder to write it like this:

var setOfStrings = new BsonValue[] { "a", "b", "c" };
var query = Query.Or(
    Query.EQ("PropertyName", "test"),
    Query.In("List", setOfStrings)
);
var cursor = collection.FindAs<C>(query);

If you want to double check what the native MongoDB query looks like you can use:

var json = query.ToJson();

which in this case shows that the equivalent MongoDB query is:

{ "$or" : [
    { "PropertyName" : "test" },
    { "List" : { "$in" : ["a", "b", "c"] } }
] }

If this is not the native MongoDB query you were looking for let me know.

p.s. There is a new query builder in version 1.5 and QueryComplete is now obsolete.

answered Jul 25, 2012 at 15:37

Robert Stam

12.2k2 gold badges42 silver badges36 bronze badges

1 Comment

user376456 Over a year ago

Thanks for the additional information, and the ToJson() method. I will use that in the shell for testing going forward. Perhaps this should be an additional question on SO, but is there any instance where the Linq query ContainsAny would be slower than the above QueryBuilder or do they generate the same MongoDB query? This thread has been helpful in my understanding Linq / Querybuilder / Mongodb shell queries

Collectives™ on Stack Overflow

C# mongodb where OR List<string>

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related