Load the referenced table of a referenced table

Question

I have multiple tables that refer to other tables in my database.

I can select the entries of one table and the refered entries. In the refered table is also a table refered.

How can I load all linked tables with one query in Microsoft Entity Framework?

Tables: Devices <=> Interfaces <=> information

https://learn.microsoft.com/en-us/ef/core/querying/related-data — CodeCaster, Feb 21 '18 at 14:37

score -1 · Answer 1 · answered Feb 21 '18 at 14:37

-1

Use Include()

using (var context = new BloggingContext()) 
{ 
    // Load all blogs and related posts 
    var blogs1 = context.Blogs 
                          .Include(b => b.Posts) 
                          .ToList(); 
}

See this

answered Feb 21 '18 at 14:37

Oscar

13,594
8
47
75

Load the referenced table of a referenced table

1 Answers1