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;
- }
Rijwan AnsariPosted Apr 23, 2021, 10:21 AM
Jignesh KumarPosted Apr 20, 2021, 2:53 AM