实体一对多高效查询

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;
posted @ 2020-04-01 11:44  唯爱金生  阅读(184)  评论(0编辑  收藏  举报