Gcobani Mkontwana

Gcobani Mkontwana

  • 547
  • 1.9k
  • 398k

Query multiple record in a query using inner-join

Apr 20 2021 1:48 AM
Hi Team
 
I have a method and want to query multiple-records using single query by using inner join 
  1. public IList < ScheduleManModel > GetScheduleManList()    
  2. {    
  3. DbAccessContext db = new DbAccessContext();    
  4. var scheduleList = (from e in db.ScheduleMan join d in db.ScheduleTbl on e.ScheduleId equals d.YearTblId select new ScheduleManModel {    
  5. Year = e.Year,    
  6. Week = e.Week,    
  7. 250 Buck = (int) e.250 Buck,    
  8. RACS = e.RACS,    
  9. YBR250 = d.YBR250    
  10. }).ToList();    
  11. return scheduleList;    
  12. }  

Answers (2)