Query multiple record in a query using inner-join

Question

Hi Team

 

I have a method and want to query multiple-records using single query by using inner join 

public IList < ScheduleManModel > GetScheduleManList()
{
DbAccessContext db = new DbAccessContext();
var scheduleList = (from e in db.ScheduleMan join d in db.ScheduleTbl on e.ScheduleId equals d.YearTblId select new ScheduleManModel {
Year = e.Year,
Week = e.Week,
250 Buck = (int) e.250 Buck,
RACS = e.RACS,
YBR250 = d.YBR250
}).ToList();
return scheduleList;
}