Use LINQ to query nested OData collection

linq odata netflix
Kyle Russell picture Kyle Russell · Apr 21, 2010 · Viewed 7.1k times · Source

I'm playing around with the new Netflix OData feed (http://odata.netflix.com/Catalog/) and having some issues. I'm trying to learn LINQ at the same time but having difficulty doing what I thought was going to be quite simple.

I'd like to return a list of Titles that match a given Genre. The Titles object contains a collection of Genres. I'm not sure how to write this query. My attempt below does not appear to work using LINQPad.

from t in Titles
where t.Genres.Name.Contains("ABC")
select t

Answer

Kyle Russell picture Kyle Russell · Apr 21, 2010

I was able to get my results using the LINQ:

from g in Genres
from t in g.Titles
where g.Name == "Horror"
select t

This way I don't need to use Expand. I can also use the URL: http://odata.netflix.com/Catalog/Genres('Horror')/Titles() to get the same results. This post by Chris Woodruff helped me understand the issue.

Related questions

OData "where ID in list" query

I have an OData service where I'm trying to filter by a list of IDs; the SQL equivalent would be something like: SELECT * FROM MyTable WHERE TableId IN (100, 200, 300, 400) The property I'm trying to filter on is typed as an Int32. …

Read More
is it possible to Query an Odata service and expand Child of Child entities?

This sounds rather simple (and maybe I'm missing the obvious here) but I can't find a solution. I know I can query an entity and return one, or many direct child entities doing this: var query = from c in Service.…

Read More
Group by in LINQ

Let's suppose if we have a class like: class Person { internal int PersonID; internal string car; } I have a list of this class: List<Person> persons; And this list can have multiple instances with same PersonIDs, for example: …

Read More