Entity Framework Does Not Get Linked Table

Question

I have simply two classes (also tables - using code-first mvc5) When I try to get user, user's company doesnt come with EF6. Why is that?

Model:

 public class TblUser
{
    public int Id { get; set; }
    public string UserName { get; set; }
    public bool Gender { get; set; }
    public string Name { get; set; }
    public string Surname { get; set; }
    public string Password { get; set; }
    public string Email { get; set; }

    public TblCompany TblCompany { get; set; }
}

  public class TblCompany
{
    public int Id { get; set; }
    public string CompanyName { get; set; }
    public string Email { get; set; }

    public List<TblUser> TblUsers { get; set; }
}

Context:

 public class DBContext : DbContext
{
    public DbSet<TblCompany> TblCompanies { get; set; }
    public DbSet<TblUser> TblUsers { get; set; }
}

Service:

      private DBContext db = new DBContext();
      public TblUser GetUserById(int id, bool showHidden = false)
    {

        return db.TblUsers.FirstOrDefault(x => x.Id == id && (!x.isDeleted || showHidden));
    }

Action:

 public class SupplierHomeController : Controller
{
    // GET: Supplier/SupplierHome
    public ActionResult Index()
    {
        UserService _srvUser = new UserService();

        //User info will be come from Session in the future
        //The User whose id is 1 is only for testing.
        TblUser u = _srvUser.GetUserById(1);

        //After that line, users's company is null! :( 
        //However there is a company linked to the user.

        SupplierDashboardViewModel model = new SupplierDashboardViewModel();
        model.TblUser = u;
        return View(model);
    }
}

When I try to get User from database, company info is getting null only. I am so confused.

score 4 · Accepted Answer · answered Mar 14 '17 at 11:08

4

You need to explicitly load the related entities. This is done with the Include() method:

public TblUser GetUserById(int id, bool showHidden = false)
{
    return db.TblUsers
        .Include(u => u.TblCompany)
        .FirstOrDefault(x => x.Id == id && (!x.isDeleted || showHidden));
}

More info here.

answered Mar 14 '17 at 11:08

DavidG

113,891
12
217
223

This works! Thank you. But in my older projects, I could get whole Entity automaticly. In this procect I have to use 'include' why? – Polat Dundar Mar 14 '17 at 11:22
@PolatFevziDündar in your older project might be you have made lazy loading is false in your context class using `context.Configuration.LazyLoadingEnabled = false;` – Curiousdev Mar 14 '17 at 11:46
1

Ok. I get it now. Thanks!! – Polat Dundar Mar 14 '17 at 12:28

score 0 · Answer 2 · answered Mar 14 '17 at 11:08

You should use Eager loading for that please read about Eager-Loading more on this LINK.Eager loading is achieved using the Include() method

  public TblUser GetUserById(int id, bool showHidden = false)
  {

    return db.TblUsers.Include(s => s.TblCompany).FirstOrDefault(x => x.Id == id && (!x.isDeleted || showHidden));
  }

Entity Framework Does Not Get Linked Table

2 Answers2