实体一对多高效查询

var head = db.Queryable<InspectionRecord>().Where(w => w.CheckNumber == checkNumber && w.InspectionUnitName == inspectionUnit).ToList();
                    foreach (var h in head)
                    {
                        h.IllegalVarieties = db.Queryable<IllegalVarieties>().Where(w => h.Id == w.InspRecId).ToList();
                    }
                    res.Data = head;

实体一对多高效查询

原文：https://www.cnblogs.com/dreamsails/p/12611472.html