EF7 Identity not loading User extended properties

Question

I have an extended IdentityUser class which contains a reference to another entity on my DB, but whenever I try to get the User with the UserManager, the referenced entity always comes empty:

My implementation of the User class

public class Usuario : IdentityUser
{
    public int ClienteID { get; set; }
    public virtual Cliente Cliente { get; set; }
}

A controller that uses the referenced property on the user

[Authorize]
[HttpGet]
public async Task<Direccion> GET()
{
    var usuario = await UserManager.FindByNameAsync(Context.User.Identity.Name);
    // Cliente will always be null
    return usuario.Cliente.Direccion;
}

I also tried removing the virtual keyword from the reference, so that it is lazy loaded, but I'm not sure that is already implemented on EF7.

Any ideas on how to achieve this?

duplicate? http://stackoverflow.com/questions/26324550/accessing-navigation-properties-from-identityuser-when-lazyloading-is-off — Steve Greene, Jun 16 '15 at 19:02
I thought that removing the virtual keyword would enable eager loading so that I wouldn´t have to change the implementation (add includes) — edua_glz, Jun 16 '15 at 19:35
You still need includes for eager loading of related entities. https://msdn.microsoft.com/en-us/data/jj574232.aspx#eager — Steve Greene, Jun 16 '15 at 19:43
Got it, thanks man!, you might want to add your comment as an answer so that I can mark it as correct =) — edua_glz, Jun 16 '15 at 19:46

score 1 · Answer 1 · edited Jun 20 '20 at 09:12

I had this issue as well and solved it with the help of the EF Core Documentation. You need to use the Include method to get the related data to populate. In my case:

Entity Class:

public class ServiceEntity
{
    public int ServiceId { get; set; }
    public int ServiceTypeId { get; set; }

    public virtual ServiceTypeEntity ServiceType { get; set; } 
     
}

Accessing my DbContext object:

public ServiceEntity GetById(int id)
{
    var service = this.DbClient.Services.Include(s => s.ServiceType).Where(c => c.ServiceId == id).FirstOrDefault();

    return service;
}

I had to make the property "virtual" as well. My understanding is EF Core needs to be able to override the properties of the related object in order to populate the values.

Also, as of this post date, EF Core does not yet support Lazy Loading, only Eager Loading and Explicit Loading.

Hope this helps!

If you need to go more than one property deep (ie - a many-to-many relationship where an intermediary table is used to map a to b), you can use `.Include(s => s.ServiceCollection).ThenInclude(sc => sc.ServiceType)` to include multiple levels of related data. More at https://learn.microsoft.com/en-us/ef/core/querying/related-data — Dave Smash, Feb 23 '17 at 19:25

EF7 Identity not loading User extended properties

1 Answers1

Linked