entity-framework - EF代码优先CTP5，对多对多表使用包含方法

Question

我有类似以下的多对多关系表。

public class Shop{
 public int Id { get; set; }
 public virtual ICollection<ShopFacility> ShopFacilities { get; set; }
}

public class ShopFacility
{
 public int Id { get; set; }        
 public int ShopId { get; set; }
 public int FacilityId { get; set; }
 public virtual Shop Shop { get; set; }
 public virtual Facility Facility { get; set; }
}

public class Facility
{
 public int Id { get; set; }        
 public virtual ICollection<ShopFacility> ShopFacilities { get; set; }
}

并且，获取商店信息。

using (var context = new DataContext())
{
 return context.Shops.Include(s => s.ShopFacilities)
                     .Include("ShopFacilities.Facility")  // This line
                     .First(x => x.Id == id);
}

我想做的是使用包含Lambda表达式的Include方法来实现多对多关系，而不是字符串。我尝试实现以下代码:

using (var context = new DataContext())
{
 return context.Shops.Include(s => s.ShopFacilities)
                     .Include(s => s.ShopFacilities.Facility)  // Cannot compile
                     .First(x => x.Id == id);
}

但是正如您所猜测的，我无法对其进行编译。实际上，第一个代码段运行良好，因此基本上可以，但是，我很好奇是否有解决方法。

任何帮助，将不胜感激，

柳

Answer 1

尝试这个:

return context.Shops.Include(s => s.ShopFacilities.Select(f => f.Facility))
              .First(x => x.Id == id);     

但是，您应该遵循@Kristof在评论中建议的内容。