Query with filter builder on nested array using MongoDB C# driver

Question

Consider the following object structure stored as documents:

public class Foo
{
    public string Id { get; set; }
    public ICollection<FooBar> Bars { get; set; }

    // ...
}

public class FooBar
{
    public string BarId { get; set; }

    // ...
}

Using a LINQ-style query with the driver I can Find all Foo that contain a FooBar BarId like this:

var foos = await m_fooCollection.Find( f => f.Bars.Any( fb => fb.BarId == "123") ).ToListAsync();

How can I achieve this same query using the FilterDefinitionBuilder instead of the in-line LINQ on Find?

.Any on a ICollection is part of the Enumerable class in the System.Linq namespace, right? — kspearrin
– kspearrin, Commented Jun 22, 2015 at 17:35
Indeed, but that method will never be called. The driver translates the expression to a mongo query. — i3arnon
– i3arnon, Commented Jun 22, 2015 at 17:39
Ok, makes sense. I guess I was more trying to express the fact that I am using LINQ style syntax rather than actual LINQ. — kspearrin
– kspearrin, Commented Jun 22, 2015 at 17:42
Yes, it doesn't really matter. Just a note to future googlers. — i3arnon
– i3arnon, Commented Jun 22, 2015 at 17:44

i3arnon · Accepted Answer · 2015-06-22 17:25:01Z

36

The query you need to perform uses the $elemMatch query operator.

So, this query using a lambda expression

var findFluent = collection.Find(f => f.Bars.Any(fb => fb.BarId == "123"));

Is equivalent to this query using the FilterDefinitionBuilder:

var findFluent = collection.Find(Builders<Foo>.Filter.ElemMatch(
    foo => foo.Bars, 
    foobar => foobar.BarId == "123"));

answered Jun 22, 2015 at 17:25

i3arnon

117k33 gold badges334 silver badges358 bronze badges

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

6 Comments

utaco Over a year ago

What if I have BarNumber property instead of BarId and there are 2 BarNumber with same value. How can I get both of them?

benjamin54 Over a year ago

@i3arnon, this returns all the Foo objects that matches the criteria with each object having ALL its FooBar children. What if I need to filter those children objects too (with BarId = "123") so not all FooBar will be present in result?

i3arnon Over a year ago

@benjamin54 I don't think you can do that with a "simple" query. I think you need to use the aggregation framework, but I'm not sure. Maybe you'd be better posing another question...

Ben Over a year ago

Hey, if Foo object has a dateTime property, which I want to find by date greaterorequal param, how would you achieve that? Doing like so doesnt work -> var findFluent = collection.Find(Builders<Foo>.Filter.ElemMatch( foo => foo.Bars, foobar => foobar.TimeCreate >= timeParam));

Rizwan Shakir Over a year ago

@benjamin54 i am looking for the same answer that you asked. I am late here but looking forward to hear form you! Please let me know if we can do that using FilterDefinitionBuilder ? otherwise projection is the option to do it.

|

Collectives™ on Stack Overflow

Query with filter builder on nested array using MongoDB C# driver

1 Answer 1

6 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Related