How to load data using include of other levels using entity fraimwork?

Question

C++ / C#

Hello, I figured out how to load data for the first 3 levels of an object, I can’t access a specific object at level 4 - it turns out that I’m accessing a list of objects.

Answer 1

In one Include, you can immediately show several nested links, then all intermediate ones will also be connected:

return (from e in db.Position
    .Include(p => p.Operations.Select(o => o.Transition.Select(t => t.RiggingTransition)))
    .Include(p => p.Operations.Select(o => o.MaterialOperation))
    where ...
    select e).ToList();

In this case, MaterialOperation and Transition should be connected in Position, in which RiggingTransition will be connected