Mongo C#: Is array field contains element from a given array

Question

I am using mongodb with the C# driver. I have an object (document) with a property of type List<ObjectId> (say arrProp).

I want to find all documents that the arrProp contains at least one element from a given array (another List<ObjectId>).

Is there a way to get the result in a single query?

Please post some code of what you have attempted so far.

Joel Gregory
– Joel Gregory

2015-02-22 21:37:57 +00:00
Commented Feb 22, 2015 at 21:37 — Joel Gregory
– Joel Gregory, Commented Feb 22, 2015 at 21:37

Pankaj Bodani · Accepted Answer · 2015-09-09 08:13:27Z

2

If you are using driver version 1.5 or later, you can simply use the contains predicate as described in this issue

https://jira.mongodb.org/browse/CSHARP-462

If you are using a driver that is pre 1.5, you can use the following extension

ContainsAny (LINQ to MongoDB extension method)

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 }));

edited Sep 9, 2015 at 8:13

answered Sep 9, 2015 at 8:03

Pankaj Bodani

3032 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Mongo C#: Is array field contains element from a given array

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