How to filter a list where I need multiple dynamic filter parameters

Question

I have a list of objects (Locations). Every location can have multiple categories. I have a list of integers (CategoryId's). Based on that I need to filter locations:

List<int> categoriesToLoad = new List<int>();
// fill list
var allLocations = locationRepository.GetLocations().Where(...
var filteredLocations = from m in model
                             where categoriesToLoad.Contains(m.LocationCategories.FirstOrDefault() == null ? -1 : m.LocationCategories.FirstOrDefault().PlaceCategoryId)
                             select m;

This works only for one category, I don't know how to fix code to compare all categories that are attached to location.

You can use Any stackoverflow.com/a/1757244/381422

xdumaine
– xdumaine

2012-09-10 21:03:32 +00:00
Commented Sep 10, 2012 at 21:03 — xdumaine
– xdumaine, Commented Sep 10, 2012 at 21:03

Joshua Honig · Accepted Answer · 2012-09-10 21:05:18Z

1

You want Any.

var filteredLocations = 
       model.Where(m => m.LocationsCategories
            .Any(c => categoriesToLoad.Contains(c.PlaceCategoryId)));

answered Sep 10, 2012 at 21:05

Joshua Honig

13.3k8 gold badges58 silver badges77 bronze badges

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

Comments

YoryeNathan · Accepted Answer · 2012-09-10 21:04:54Z

1

Try to replace this:

var filteredLocations = from m in model
                        where categoriesToLoad.Contains(m.LocationCategories.FirstOrDefault() == null ? -1 : m.LocationCategories.FirstOrDefault().PlaceCategoryId)
                        select m;

with this:

var filteredLocations = from m in model
                        where m.LocationCategories.Any(x => categoriesToLoad.Contains(x.PlaceCategoryId)
                        select m;

Though I don't really understand fully what you're trying to do and whats the logic of your application, so it is possible that all I've said is crap.

answered Sep 10, 2012 at 21:04

YoryeNathan

14.6k5 gold badges42 silver badges61 bronze badges

Comments

david.s · Accepted Answer · 2012-09-10 21:04:55Z

1

You can do somthing like this:

var filteredLocations = locationRepository
                            .GetLocations()
                            .Where(l => l.LocationCategories.Any(x => categoriesToLoad.Contains(x.PlaceCategoryId));

answered Sep 10, 2012 at 21:04

david.s

11.4k6 gold badges54 silver badges83 bronze badges

Collectives™ on Stack Overflow

How to filter a list where I need multiple dynamic filter parameters

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related