使用从LINQ到Entites的数据填充包含其他ViewModel的ViewModel

我刚刚完成了第一个综合体的构建，那么我认为它很复杂ViewModel。它包含嵌套ViewModels，我很难弄清楚如何使用来填充数据LINQ to Entities。我应该如何填满整个图表？

我的ViewMode：

public class TimesheetWeeklyTableVM
{
    public int TimesheetHeaderID { get; set; }
    //public DateTime weekEndingDate { get; set; }
    public decimal TotalWeekHours { get; set; }

    public List<TimesheetDailyVM> DaysOfWeek { get; set; }

    public TimesheetWeeklyTableVM(DateTime weekEndingDate)
    {
        DaysOfWeek = new List<TimesheetDailyVM>();

        for (var i = 6; i >= 0; i--)
        {
            DaysOfWeek.Add(new TimesheetDailyVM()
            {
                CurrentDate = weekEndingDate.AddDays(-i)
            });
        }
    }
}

public class TimesheetDailyVM
{
    public DateTime CurrentDate { get; set; }

    public double TotalHours
    {
        get
        {
            return TimeSpan.FromSeconds(Tasks.Sum(p => (p.StartDateTime - p.EndDateTime).TotalSeconds)).TotalHours;
        }
    }

    public IEnumerable<TimesheetDailyHoursVM> Tasks { get; set; }

    public TimesheetDailyVM()
    {
        Tasks = new List<TimesheetDailyHoursVM>();
    }
}

public class TimesheetDailyHoursVM
{
    public int TimesheetID { get; set; }
    public DateTime StartDateTime { get; set; }
    public DateTime EndDateTime { get; set; }
    public string ProjectCode { get; set; }
    public string ProjectDescription { get; set; }
    public string TaskCode { get; set; }
    public string TaskDescription { get; set; }
}

我将要提取的数据表中的实体：

public class TimesheetHeader
{
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int ID { get; set; }

    public int EmployeeID { get; set; }
    public DateTime WeekEndingDate { get; set; }
    public decimal TotalHours { get; set; }
    public int CurrentStatusID { get; set; }

    public decimal OtherPay { get; set; }
    public int? ApprovedByID { get; set; }
    public DateTime? DateSubmitted { get; set; }
    public DateTime? DateApproved { get; set; }

    [Column(TypeName = "varchar(MAX)")]
    public string ManagerNotes { get; set; }

    [ForeignKey("EmployeeID")]
    public Employee Employee { get; set; }

    [ForeignKey("ApprovedByID")]
    public Employee ApprovedBy { get; set; }

    [ForeignKey("CurrentStatusID")]
    public StatusOption CurrentStatus { get; set; }
}

public class Timesheet
{
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int ID { get; set; }

    public int TimesheetHeaderID { get; set; }
    public DateTime StartDateTime { get; set; }
    public DateTime EndDateTime { get; set; }
    public string ProjectCode { get; set; }
    public string TaskCode { get; set; }

    [Column(TypeName = "varchar(MAX)")]
    public string WorkDescription { get; set; }

    [ForeignKey("TimesheetHeaderID")]
    public TimesheetHeader TimesheetHeader { get; set; }
}

到目前为止，我要填写的代码：

            var weekEndingDate = TimesheetHelper.GetWeekEndingDate(date);

            using (var db = new JobSightDbContext())
            {
                var model = db.TimesheetHeaders
                              .Where(timesheet => timesheet.WeekEndingDate == weekEndingDate)
                              .Select(timesheet => new TimesheetWeeklyTableVM(weekEndingDate)
                              {
                                  TimesheetHeaderID = timesheet.ID,
                                  TotalWeekHours = timesheet.TotalHours
                              }).FirstOrDefault();

                model.DaysOfWeek = db.Timesheets
                                     .Where(timesheet => timesheet.TimesheetHeaderID == model.TimesheetHeaderID)
                                     .OrderBy(timesheet => timesheet.StartDateTime)
                                     .Select(timesheet => new TimesheetDailyVM()
                                     {   
                                         Tasks.TimesheetID = timesheet.ID,
                                         StartDateTime = timesheet.StartDateTime,
                                         EndDateTime = timesheet.EndDateTime,
                                         ProjectCode = timesheet.ProjectCode,
                                         TaskCode = timesheet.TaskCode
                                     }).ToList();

                return PartialView(model);
            }

这段代码给我错误“在当前上下文中不存在名称'Tasks'。无效的初始化成员声明”和“ TimesheeDailyVM不包含'XXX'的定义”的错误。

如果我尝试插入case，TimesheetDailyHoursVM那么我会得到一个隐式转换错误。