Entity Framework: loading second-level navigation properties

Question

I have the following three tables:

Customers: I would have ClientName

Projects: I would clientid (int ref to Clients.id) the name of the project projectstatus (int ref to ProjectStatuses.id)

ProjectStatuses: I would have statusname

I select one client and, if necessary, load the selected client projects as follows:

selectedClient.Projects.Load ();

but how do I upload it the project status file?

Answer 1

selectedClient.Projects.ProjectStatuses.Load()

Edit

This is a one-to-many relationship that I think

it should work

selectedClient.Projects.First().ProjectStatuses.Load()

or you can also load it directly into your request using

context.Clients.Include("Projects.ProjectStatuses");