EF Join to fetch data from multiple tables

C# Corner

Dave Bell

3y883Entity Framework

I have below entities

Student : Id, Name, .... Event : PId, SId, Name, ... , Subject[] Subject : SId, Name...

I wish to pull all Events and Subjects for given student and include Student Name only from Student

How to I join to get Student Name as well.

So far I have done

_context.event.Where(b => b.SId == request.Id).Include(c => c.Subject)

This gives me list of all Events and Subjects within each Event. How to get Student Id and Name as well...I dont mind it coming for all events.

E.g.
Id, Name, Event1 {Subjects[]},
Id, Name, Event2 {Subjects[]},

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Naimish Makwana3y ago

Hello Dave,

Try below.

var result = _context.event
    .Where(e => e.SId == request.Id)
    .Include(e => e.Subject)
    .Join(_context.student, e => e.SId, s => s.Id, (e, s) => new {
        s.Id,
        s.Name,
        Event = e
    })
    .ToList();

Thanks

Naimish Makwana