CODEWITHSUNDEEP
c#entity-framework
Coesy
Coesy

Reputation: 936

Entity Framework Populating Child Objects using Foreign Key

I hope this isn't a duplicate as I have been looking but I was looking more at the reasoning behind this.

I have set up a user object. 

public class User
{
    public User()
    {

    }

    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int UserID { get; set; }
    public Guid UserGuid { get; set; }
    public string Email { get; set; }
    public string Name { get; set; }
    public int CompanyID { get; set; }
    public int StatusID { get; set; }
    [ForeignKey("StatusID")]
    public Status Status { get; set; }
    public int RoleID { get; set; }
    [ForeignKey("RoleID")]
    public UserRole UserRole { get; set; }
}

And the Child Objects

public class UserRole
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int RoleId { get; set; }
    public string Role { get; set; }
}

public class Status
{
    [Key]
    public int StatusId { get; set; }
    public string Description { get; set; }
}

When I call 

var testuser = dbContext.User.Where(u => u.CompanyID == 1).FirstOrDefault();

I get users.Status as being null, but users.StatusID = 1.

however, if I call

var status = dbContext.Status.ToList();
var role = dbContext.UserRole.ToList();
var testuser = dbContext.User.Where(u => u.CompanyID == 1).FirstOrDefault();

then call testuser.Status, I can see the correct object related to StatusId of 1.

Can someone explain why this would solve the issue and also how I can make it work without having to call the following beforehand.

var status = dbContext.Status.ToList();

Thanks

Upvotes: 3

Views: 3473

Answers (2)

tadej
tadej

Reputation: 711

Just use your property like this. Keyword virtual put its property to lazy loading and then you can access the whole object.

public virtual Status Status { get; set; }

And BTW, I edited your class. There are un-needed things, because you can access StatusID by property Status (like int statID = Status.StatusID;) and same to UserRole.

public class User
{
    public User()
   {

   }

   [Key]
   [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
   public int UserID { get; set; }
   public Guid UserGuid { get; set; }
   public string Email { get; set; }
   public string Name { get; set; }
   public int CompanyID { get; set; }
   public virtual Status Status { get; set; }
   public virtual UserRole UserRole { get; set; }
   }
}

Upvotes: 2

Sampath
Sampath

Reputation: 65938

You can try as shown below.

Note : Use Eager loading with Include()

Eager loading is the process whereby a query for one type of entity also loads related entities as part of the query

using System.Data.Entity;

var testuser = dbContext.User.Where(u => u.CompanyID == 1)
                              .Include(p => p.Status)        
                              .FirstOrDefault();

Upvotes: 5

Related Questions