c# – Entity Framework 6,急切加载嵌套关系返回空集合

public class User
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedoption.Identity)]
    public virtual int UserId { get; set; }

    private ICollection<Recipe> _recipes;
    public virtual ICollection<Recipe> Recipes
    {
        get { return _recipes ?? new List<Recipe>(); } 
        set { _recipes = value; }
    } 
}

public class Recipe
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedoption.Identity)]
    public int RecipEID { get; set; }

    private ICollection<Ingredient> _ingredients;
    public virtual ICollection<Ingredient> Ingredients
    {
        get { return _ingredients ?? new List<Ingredient>(); } 
        set { _ingredients = value; }
    }
    public User User { get; set; }
}

public class Ingredient
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedoption.Identity)]
    public int IngredientId { get; set; }

    public Recipe Recipe { get; set; }
}

简而言之,用户与Recipe有一对多的关系,而Recipe与Ingredient之间存在一对多的关系.我正在使用代码第一种方法,在受保护的覆盖中使用此映射void OnModelCreaTing(DbModelBuilder modelBuilder)：

@H_878_7@modelBuilder.Entity<User>() .Hasmany(u => u.Recipes) .Withrequired(u => u.User) .WillCascadeOndelete(true); modelBuilder.Entity<Recipe>() .Hasmany(u => u.Ingredients) .Withrequired(u => u.RecipE) .WillCascadeOndelete(true);

我正在使用存储库,它具有此代码将数据存储到MysqL数据库中：

public void Add(User entity)
{
    using (var co@R_944_10443@t = new UserCo@R_944_10443@t())
    {
        co@R_944_10443@t.Users.Add(entity);
        co@R_944_10443@t.SaveChanges();
    }
}

和取：

public User GetById(int id)
{
    using (var co@R_944_10443@t = new UserCo@R_944_10443@t())
    {
        var user = co@R_944_10443@t.Users
            .Include(u => u.Recipes)
            .Include(u => u.Recipes.SELEct(x => x.Ingredients))
            .FirstOrDefault(u => u.UserId == id);

        return user;
    }
}

我有集成测试,它创建一个User对象,List< Recipe>具有两个配方,其中每个配方具有List< Ingredient>有2件物品.每种食谱都有所不同,总共有4种成分.当我将它添加到存储库时,我可以在数据库中看到它具有正确的PK和FK.

但是,从数据库中检索时,返回的User对象具有配方,但这些配方都没有配方.由于我设置我的getter的方式,当我尝试访问它们时,我收到一个空集合.

例如这样做：

/* create recipes collection and seed it */

User user = new User {Recipes = recipes /* plus some omitted properites*/};
_repository.Add(user);

var returnedUser = _repository.GetById(user.UserId);

var userIngredients = user.Recipes.First(u => u.Recipename == "Test").Ingredients.ToList();
var returnedIngredients = returnedUser.Recipes.First(u => u.Recipename == "Test").Ingredients.ToList();

returnedIngredients为空,而userIngredients有两个元素.然后这会失败断言并导致集成测试失败.

有人能告诉我如何在嵌套的一对多上正确地进行加载吗？