entity-framework - EF 代码优先 : How to load related data (parent-child-grandchild)?

Question

我有这个实体:

public class DynamicPage {

    public int PageId { get; set; }

    public int Order { get; set; }

    public string MenuText { get; set; }

    public string MenuHover { get; set; }

    public int? ParentId { get; set; }

    public virtual DynamicPage Parent { get; set; }

    public virtual ICollection<DynamicPage> Children { get; set; }
}

该实体可能有 3 个级别:父级 -> 子级 -> 孙级。如何加载父级(级别 1)与所有关联的子级(级别 2)以及每个子级的关联孙子级(级别 3)(如果有)？感谢帮助。

Answer 1

EF 4.1 特性和语法:

var entity = context.Parents
    .Include(p => p.Children.Select(c => c.GrandChildren))
    .FirstOrDefault(p => p.Id == 1); // or whatever condition