如何在EF中包含2个导航属性？ [英] How to include 2 navigational properties in EF?

问题描述

我的数据库中的一个对象有两个导航属性（B和C）：

An object in my database has 2 navigational properties (B and C):

Object A
{
  B bProperty

  C cProperty
}

我希望在查询对象A时包含它们。
我尝试执行以下操作：

I wish to include them both when querying object A. I tried doing the following:

dbcontext.A.Include(x => x.B).ToList();

但是如何包括C？

推荐答案

尝试这个

dbcontext.A.Include（x => xB）.Include（x => xC） （）;

dbcontext.A.Include(x => x.B).Include(x => x.C).ToList();

我一直都这样做，所以在我的EF存储库类中，我有一个叫GetAllIncluding的方法，它等于以每个实体的通用方式，

I do it all in one go, so in my EF repository class, I have a method called GetAllIncluding which equals do it in a generic way for each entity,

public IQueryable<T> GetAllIncluding(params Expression<Func<T, object>>[] includes)
{
    var query = DbSet.AsNoTracking();

    query = includes.Aggregate(query, (current, includeProperty) => current.Include(includeProperty));

    return query;
}

其中DbSet是IDbSet类型的私有成员，T是BaseEntity类型

where DbSet is a private member of type IDbSet and T is a of type BaseEntity.

，我使用的方式就是这样。

and the way I use it is like this

   MyGenericRepository<A>().GetAllIncluding(x=> x.B, x=> x.C).FirstOrDefault();

希望有所帮助。

这篇关于如何在EF中包含2个导航属性？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！