Nested query problem

Question

I have 3 classes in C#:

class Folder
{
    int Id { get; set; }
    List<File> files { get; set;}
}

class File
{
    int Id { get; set; }
    Author author { get; set; }
}

class Author
{
    int Id { get; set; }
    string Name { get; set; }
}

I have a list of Folder items (List):

var folders = getAllFolders();

How can I use Linq to return a list of Folders from the list when i only know the Author id of the files?

I need the list to contain all folders where a given Author has created a file!

Thanks

tvanfosson · Accepted Answer · 2010-05-10 12:13:57Z

4

You want to find the folders where Any of the files have the Author id equal to the one you are looking for.

var authFolders = folders.Where( fo => fo.files.Any( fi => fi.Author.Id == authorId ));

edited May 10, 2010 at 12:13

answered May 10, 2010 at 11:51

tvanfosson

534k102 gold badges703 silver badges801 bronze badges

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

1 Comment

tvanfosson Over a year ago

@Kobi -- yep. I keep saying that SO needs intellisense, but they keep ignoring me. :-)

Collectives™ on Stack Overflow

Nested query problem

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related