Many developers are creating the View in database for tables’ relationship. Revisit Nancy ADO sample in 2010. I do think that it is a good way to loop through the parent-child relationship without creating a view.
The edmx model as below.
The loop is like below.
foreach (Course c in context.Courses)
foreach (Video v in c.Videos)