我有一個(gè)父母/子女關(guān)系的模型。Year和WeekYears: YearID, NameWeeks: WeekID, YearID, Name因此，如果我有YearSelected，要獲得一年中的所有周數(shù)，我會(huì)：List<Week> weeks = db.weeks.Where(w => w.YearID == model.YearSelected).ToList();model.WeekList = new SelectList(weeks, "WeekID", "Name");但是在數(shù)據(jù)庫中我只保存WeekID所以只有model.WeekSelected所以我如何獲得同年的同一周 model.WeekSelected我可以先查詢以獲取YearID，但想知道是否可以在一行中完成。int YearID = db.weeks.Where(w => w.WeekID == model.WeekSelected)                     .SingleOrDefault().YearID.Value;