Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

linq question: querying nested collections

I have a Question class that has public List property that can contain several Answers.

I have a question repository which is responsible for reading the questions and its answers from an xml file.

So I have a collection of Questions (List) with each Question object having a collection of Answers and I'd like to query this collection of Questions for an Answer (ie by its Name) by using Linq. I don't know how to do this properly.

I could do it with a foreach but I'd like to know whether there is a pure Linq way since I'm learning it.

like image 795
kitsune Avatar asked Apr 06 '09 13:04

kitsune


1 Answers

To find an answer.

questions.SelectMany(q => q.Answers).Where(a => a.Name == "SomeName") 

To find the question of an answer.

questions.Where(q => q.Answers.Any(a => a.Name == "SomeName")) 

In fact you will get collections of answers or questions and you will have to use First(), FirstOrDefault(), Single(), or SingleOrDefault() depending on your needs to get one specific answer or question.

like image 83
Daniel Brückner Avatar answered Sep 20 '22 02:09

Daniel Brückner