LINQ Search in collection of object containing object which contains list

Question

please help in creating simple c# Linq query

List<A> X;

class A{
public string phone;
...some other props
}
class B{
public string xyz;
public List<B> bobj;
}
class C{
public string pqr;
public B;
}
..

Now I have list of C;

List<C> tobesearched;

How to get all C i.e. List<C> from tobesearched for a phone which contains "123"

I believe bobj should be of type List<A>. But anyway, what did you try so far? Can you show your query and describe results you got with that query — Sergey Berezovskiy
– Sergey Berezovskiy, Commented Dec 24, 2019 at 23:13
Frankly, no clue.. cad.SelectMany(s => s.Customer.phonenumbers) .FirstOrDefault(s => s.phone == kp.Value)) — Dheeraj Dhondalkar
– Dheeraj Dhondalkar, Commented Dec 24, 2019 at 23:17
your tobesearched list does not include any A not sure how would you like to search for any phone in it. — Tim
– Tim, Commented Dec 24, 2019 at 23:26

div · Accepted Answer · 2019-12-24 23:41:46Z

1

If I understood your question correctly, you're looking to filter your List<C> where any B has a bobj which has a phone containing 123, right?

IEnumerable<C> result = tobesearched.Where(t => t.b.bobj.Any(u => u.phone.Contains("123")));

..or with the class you posted in the comment below:

IEnumerable<Cdaily_snapshot> result = 
        tobesearched.Where(t => t.customer.phonenumbers.Any(u => u.phone.Contains("123")));

edited Dec 24, 2019 at 23:41

answered Dec 24, 2019 at 23:22

div

9251 gold badge7 silver badges20 bronze badges

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

4 Comments

Dheeraj Dhondalkar Over a year ago

yes correct, but your solution didn't work. List<C> result = tobesearched.Where(t => t.b.bobj.Any(u => u.phone.Contains("123"))); it returns List of B not C

Dheeraj Dhondalkar Over a year ago

Here is my actual classes

class Cdaily_snapshot{ public Customer customer;} class Customer{List<CphoneNumbers> phonenumbers;} class CphoneNumbers{public bool isDefault; public string phone;}

Now in another class I have List<Cdaily_snapshot> cad; need to find all List<Cdaily_snapshot> from cad where phone is like 123 Sorry I dont know how to put it properly. Evertime I press enter, it is getting posted.

div Over a year ago

I edited my answer. This expression does indeed return an IEnumerable<Cdaily_snapshot>.

Dheeraj Dhondalkar Over a year ago

Sorry man it worked. Just added ToList<C>(). Thanks for help!

Collectives™ on Stack Overflow

LINQ Search in collection of object containing object which contains list

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related