C# - Nested LINQ queries

Question

Let's say I have a list of objects that I want to filter:

using System;
using System.Collections.Generic;
using System.Linq;

public class Person
{
    public string Name;
    public int Age;
    public List<int> Attributes;

}
class HelloWorld
{
    static void Main()
    {
        var p1 = new Person();
        p1.Name = "john";
        p1.Attributes = new List<int> { 1, 2, 3, 6, 9 };
        p1.Age = 25;

        var p2 = new Person();
        p2.Name = "steve";
        p2.Attributes = new List<int> { 2, 5, 9, 10 };
        p2.Age = 47;

        List<Person> people = new List<Person> { p1, p2 };

        people.Where(p=>p.Age > 20)
            .Where(p=>p.Attributes ?????);
    }
}

How would I query for People objects with an Attribute over a threshold (say >10)? It seems like I would need a 2nd query but I can't figure out how to nest them.

Prasad Telkikar · Accepted Answer · 2021-10-27 05:17:58Z

3

You can use Any(). No need to use multiple Where() clause, you can include multiple conditions into one Where() clause

Any() : Determines whether any element of a sequence exists or satisfies a condition.

var thresholdValue = 10; 
var result = people.Where(   //Filter list of people based on below conditions
              p=>p.Age > 20 &&   //Age should be greater than 20
              //**Atleast one** attribute should be greater than thresholdValue
              p.Attributes.Any(x => x > thresholdValue));

I used && operator because in question it looks like you want to filter people which satisfies both the condition.

edited Oct 27, 2021 at 5:17

answered Oct 27, 2021 at 4:59

Prasad Telkikar

16.1k7 gold badges26 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

C# - Nested LINQ queries

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