.NET Core 2.1 Identity get all users with their associated roles

by

I have now implemented the following solution.

As CodeNotFound pointed out in the comments, IdentityUser used to have a Roles property. This is no longer the case in .NET Core. This comment/issue on GitHub seems to be the current solution for .Net Core. I have attempted to implemented it with the following code:

ApplicationUser

public class ApplicationUser : IdentityUser
{
    public ICollection<ApplicationUserRole> UserRoles { get; set; }
}

ApplicationUserRole

public class ApplicationUserRole : IdentityUserRole<string>
{
    public virtual ApplicationUser User { get; set; }
    public virtual ApplicationRole Role { get; set; }
}

ApplicationRole

public class ApplicationRole : IdentityRole
{
    public ICollection<ApplicationUserRole> UserRoles { get; set; }
}

DBContext

public class ApplicationDbContext
    : IdentityDbContext<ApplicationUser, ApplicationRole, string, IdentityUserClaim<string>,
    ApplicationUserRole, IdentityUserLogin<string>,
    IdentityRoleClaim<string>, IdentityUserToken<string>>
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
        : base(options)
    {
    }

    protected override void OnModelCreating(ModelBuilder builder)
    {
        base.OnModelCreating(builder);

        builder.Entity<ApplicationUserRole>(userRole =>
        {
            userRole.HasKey(ur => new { ur.UserId, ur.RoleId });

            userRole.HasOne(ur => ur.Role)
                .WithMany(r => r.UserRoles)
                .HasForeignKey(ur => ur.RoleId)
                .IsRequired();

            userRole.HasOne(ur => ur.User)
                .WithMany(r => r.UserRoles)
                .HasForeignKey(ur => ur.UserId)
                .IsRequired();
        });
    }
}

Startup

services.AddIdentity<ApplicationUser, ApplicationRole>(options => options.Stores.MaxLengthForKeys = 128)
            .AddEntityFrameworkStores<ApplicationDbContext>()
            .AddDefaultTokenProviders();

Finally, make sure when you’re using it that you eagerly load the User’s UserRoles, and then the UserRole’s Role like so:

this.Users = userManager.Users.Include(u => u.UserRoles).ThenInclude(ur => ur.Role).ToList();

I had an issue where the Role property of each UserRole was null and this was resolved by adding in the .ThenInclude(ur => ur.Role) part.

Microsoft doc on multi-level eager loading: https://docs.microsoft.com/en-us/ef/core/querying/related-data#including-multiple-levels

ASP Core 2.2 update

Inherent from IdentityUserRole<Guid> not string
You may also need to remove the code in the ModelBuilder to get migrations working.

More Related Contents:

  1. How to load navigation properties on an IdentityUser with UserManager
  2. Dynamically change connection string in Asp.Net Core
  3. Dynamically access table in EF Core 2.0
  4. How to mock an async repository with Entity Framework Core
  5. .Net Core 3.0 possible object cycle was detected which is not supported
  6. Cannot access a disposed object in ASP.NET Core when injecting DbContext
  7. How to instantiate a DbContext in EF Core
  8. Unable to create migrations after upgrading to ASP.NET Core 2.0
  9. Dynamically changing schema in Entity Framework Core
  10. How to unapply a migration in ASP.NET Core with EF Core
  11. How to return 401 instead of 302 in ASP.NET Core?
  12. EF CORE 2.1 HasConversion on all properties of type datetime
  13. Multiple Identities in ASP.NET Core 2.0
  14. Is there an Entity Framework 7 Database-First POCO Generator?
  15. How to make EF-Core use a Guid instead of String for its ID/Primary key
  16. ASP.NET Core Identity 2.0 SignoutAsync is not logging out user if the user signed in with Google
  17. loading a full hierarchy from a self referencing table with EntityFramework.Core
  18. In-memory database doesn’t save data
  19. Avoid or control circular references in Entity Framework Core
  20. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  21. Identity UI no longer works after switching to .net core 3 endpoint routing
  22. Add migration with different assembly
  23. ASP – Core Migrate EF Core SQL DB on Startup
  24. How to give custom implementation of UpdateAsync method of asp.net identity?
  25. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  26. How to get user information in DbContext using Net Core
  27. How should I manage DbContext Lifetime in MVC Core?
  28. Implementing recursive property loading in EF Core
  29. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  30. Unable to resolve service for type ‘Microsoft.AspNetCore.Identity.UserManager` while attempting to activate ‘AuthController’

Leave a Comment