Fetching multiple levels of related records in Entity Framework .NET5

Question

I have the following code. It brings back the Show and its related Slides. However Slide also has related Items but I have no idea how to make the query include those (There is a foreign key in the db).

Show sh = (from s in _context.Shows
           where s.ShowId == id
           select new Show()
           {
               ShowId=s.ShowId,
               ShowName=s.ShowName,
               Slides=s.Slides           
           }).FirstOrDefault();

How do I modify this to make it also fetch the list of Items for each Slide?

I am using .Net5

Is there a reason you are not using LINQ for the whole query? — CompiledIO
– CompiledIO, Commented Apr 13, 2021 at 9:02
Yes, I do not like it. Linq Query Syntax is entirely valid code and in many cases looks nicer in my mind. This Query could get quite complex. It just looks simple right now. — coolblue2000
– coolblue2000, Commented Apr 13, 2021 at 9:13
@CompiledIO What is not LINQ in this query? Query syntax is also LINQ, if that is what you mean. — Gert Arnold
– Gert Arnold, Commented Apr 13, 2021 at 9:32

Marius Steinbach · Accepted Answer · 2021-04-13 09:19:15Z

1

If you defined your DbContext correctly the LINQ would be

Show sh = _context.Shows
    .Where(s => s.ShowId == id)
    .Include(s => s.Slides)
    .ThenInclude(sl => sl.Items)
    .FirstOrDefault();

answered Apr 13, 2021 at 9:19

Marius Steinbach

6369 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

coolblue2000 Over a year ago

This works thanks. Just to complete the Answer. In Query Syntax the code is Show sh = (from s in _context.Shows where s.ShowId == id select s).Include(x=>x.Slides).ThenInclude(x=>x.Panes).FirstOrDefault();

Collectives™ on Stack Overflow

Fetching multiple levels of related records in Entity Framework .NET5

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related