如何在LINQ表达式中包含多个层次？

debugcn 发表于 Dev

用户名

我有以下课程：

public partial class Exam
{
    public Exam()
    {
        this.Objectives = new List<Objective>();
    }
    public int ExamId { get; set; }
    public string Name { get; set; }
    public virtual ICollection<Objective> Objectives { get; set; }
}
public partial class Objective

    public Objective()
    {
        this.ObjectiveDetails = new List<ObjectiveDetail>();
    }

    public int ObjectiveId { get; set; }
    public int ExamId { get; set; }
    public string Text { get; set; }
    public virtual Exam Exam { get; set; }
    public virtual ICollection<ObjectiveDetail> ObjectiveDetails { get; set; }
}

public partial class ObjectiveDetail
{
    public ObjectiveDetail()
    {
        this.SubTopics = new List<SubTopic>();
    }
    public int ObjectiveDetailId { get; set; }
    public int ObjectiveId { get; set; }
    public int Number { get; set; }
    public string Text { get; set; }
    public virtual Objective Objective { get; set; }

}

我创建了以下文件以获取考试和目标数据：

        var exam = _examsRepository.GetAll()
            .Where(e => e.Name == name)
            .Include(e => e.Objectives)
            .FirstOrDefault();

但是，如何也可以包含ObjectiveDetails呢？

谢尔盖·卡里尼琴科（Sergey Kalinichenko）

像这样：

var exam = _examsRepository.GetAll()
    .Where(e => e.Name == name)
    .Include(e => e.Objectives)
    .Include(e => e.Objectives.Select(o => o. ObjectiveDetails))
    .FirstOrDefault();

有关加载相关实体的MSDN文章。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。