C# EF Linq 子查询

需求：查询员工最近一条的申请数据

 DateTime bdate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
 DateTime edate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 23:59:59"));

                 var list = from Check in db.O_Check
                           join a in (from c in db.O_Check
                                      where (c.GoTime >= bdate && c.GoTime <= edate)//今天
                                      && c.CheckState == 1//审核
                                      group c by c.ApplicantStaffID into g
                                      select new
                                      {
                                          g.Key,
                                          ID = g.Max(a => a.ID)
                                      }) on Check.ID equals a.ID
                           select new
                           {
                               Check.ID,
                               Check.ApplicantStaffName,
                               Check.LeaveState,
                               Check.IsCar,
                               Check.CarNumber
                           };