var list1 = (from w in db.Weeks from p in db.ProductionDays on w.WeekId = p.WeekId // Error here from m in db.Models on p.ProductionDate = m.CreatedDate // Error here where (myModels.Contains(m.Name.ToString().ToUpper())) select { w.Year, w.WeekNum, p.ProductionDate, p.DayOfWeek, m.Name, m.Code, m.InActive }).ToList();
join
from
from w in db.Weeks join p in db.ProductionDays on w.WeekId equals p.WeekId join m in db.Models on p.ProductionDate equals m.CreatedDate
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)