C# MongoDb Driver Filter using nested property from collection

Question

I have the following class structures :

public class QuoteRequestInfo
{
      . . . 
    public LocationInfo LocationInfo {get;set;}
     . . .
}

LocationInfo has a stop collection which will always contain 2 stops :

public class LocationInfo
{
    . . . 
    public IEnumerable<Stop> Stops{get;set};
     . . .
}

Stop has the following property :

public class Stop
{
    . . . 
    public string StateName {get;set};
     . . .
}

I am trying to search QuoteRquestInfos collection by filtering on multiple state names like so :

var states = new List<string> {"VA"}
var filter =  Builders<QuoteRequestInfo>.Filter.In(r => r.LocationInfo.Stops.First().StateCode, states)
var quotes = await collection.Find(filter).ToListAsync();

This is returning an empty filter and not matching anything? how should I be passing in the expression to the In Filter ? any ideas ?

dododo · Accepted Answer · 2022-05-21 23:02:14Z

1

There are a lot of ways, for example:

        var states = new List<string> { "VA" };
        var quotes = coll.AsQueryable()
            .Select(c =>
                new {
                    Previous = new QuoteRequestInfo { LocationInfo = c.LocationInfo }, // this partocular line saves the previous document
                    StoredFirst = c.LocationInfo.Stops.First().StateName }) // save a flag about first stop since call it in the same construction with `Where` is not supported via typed way
            .Where(f => states.Contains(f.StoredFirst))
            .Select(c => c.Previous)
            .ToList();

answered May 21, 2022 at 23:02

dododo

4,7832 gold badges19 silver badges48 bronze badges

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

3 Comments

RedRose Over a year ago

Thanks for you answer, Thic could work but I was specifically trying to find a solution with out converting the Collection to Queryable .

dododo Over a year ago

it doesn't matter. AsQueryable just calls Aggregate behind the scene. So you can replace the above Select on Aggregate.Project and Where on Aggregate.Match. As I can see, you can't use Find only because it doesn't support using Projection before filtering

dododo Over a year ago

If you need Find, you can simply provide a filter in raw MQL form like: var quotes = await collection.Find("{ whatever : 1 }").ToListAsync();

Collectives™ on Stack Overflow

C# MongoDb Driver Filter using nested property from collection

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related