UserManager.IsInRole returns false

Question

I have a seeded user that is created and then added to the role "SuperAdmin". Yet when trying to perform "IsInRole" from the user manager , I always get "false".

I have turned on lazy loading as suggested in previous answers I found, with no luck.

In my database I see the entry in the IdentityUserRole table. It contains the correct user id and roleid. The userId matches my accounts id on my ApplicationUser table

Note: I did move my context and applicatuonuser out of the web project and into my DAL project

My new context derives from IdentityDbContext and passes in as the generic user. I believe this has something to do with it as when I look at the table 'IdentityUserRole' I see the following columns

UserID | RoleID | ApplicationUser_ID | Role_ID

when I run a profiler I see that entityframework attempts to join the role with the ApplicationUser_ID. Yet this is null. The UserID is what is populated

My Controller (where it returns false

   var t = HttpContext.GetOwinContext().GetUserManager();
            //next line Fails due to FK, because user is already in role...
            //t.AddToRole(User.Identity.GetUserId(), "SuperAdmin");

            var users = UserManager.Users;

            bool ffalse = t.IsInRole(User.Identity.GetUserId(), "SuperAdmin");
            var false2 = User.IsInRole("SuperAdmin");
            var false3 = UserManager.IsInRole(User.Identity.GetUserId(), "SuperAdmin");

My DataContext

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Data.Entity.Migrations;
using System.Data.Entity.ModelConfiguration.Conventions;
using System.Linq;
using System.Runtime.Remoting.Contexts;
using Microsoft.AspNet.Identity;
using Microsoft.AspNet.Identity.EntityFramework;
using OrangeBasement.Models;

namespace OrangeBasement.DAL
{
    public class ObContext : IdentityDbContext
    {
        public ObContext()
            : base("DefaultConnection", throwIfV1Schema: false)
        {
            Configuration.LazyLoadingEnabled = true;
            Database.SetInitializer(new ObContextInitializer());
        }

        public static ObContext Create()
        {
            return new ObContext();
        }

        public DbSet Accounts { get; set; }
        public DbSet Blogs { get; set; }
        public DbSet BlogEntries { get; set; }
        public DbSet Portfolios { get; set; }
        public DbSet PortfolioEntries { get; set; }
        public DbSet PortfolioEntryTypes { get; set; }
        public DbSet ObImages { get; set; }
        public DbSet Testimonials { get; set; }
        public DbSet TestimonialEntries { get; set; }
        public DbSet Specials { get; set; }
        public DbSet IndexMessages { get; set; }
        public DbSet ObUsers { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            this.Configuration.LazyLoadingEnabled = true;
            modelBuilder.Entity().HasKey(l => l.UserId);
            modelBuilder.Entity().HasKey(r => r.Id);
            modelBuilder.Entity().HasKey(r => new { r.RoleId, r.UserId });
            modelBuilder.Conventions.Remove();
            modelBuilder.Conventions.Remove();
        }

        public class ObContextInitializer : DropCreateDatabaseIfModelChanges
        {
            protected override void Seed(ObContext context)
            {
                if (!context.Roles.Any(r => r.Name == "SuperAdmin"))
                {
                    var store = new RoleStore(context);
                    var manager = new RoleManager(store);
                    var role = new IdentityRole {Name = "SuperAdmin"};

                    manager.Create(role);
                }

                if (!context.Users.Any(u => u.Email == "mail@gmail.com"))
                {
                    var store = new UserStore(context);
                    var manager = new UserManager(store);
                    var passwordHash = new PasswordHasher();
                    var password = passwordHash.HashPassword("password");
                    var user = new ApplicationUser
                    {
                        UserName = "mail@gmail.com",
                        PasswordHash = password,
                        Email = "mail@gmail.com",

                    };

                    manager.Create(user);
                    manager.AddToRole(user.Id, "SuperAdmin");
                }

                if (!context.Users.Any(u => u.Email == "thesteve@gmail.com"))
                {
                    var store = new UserStore(context);
                    var manager = new UserManager(store);
                    var passwordHash = new PasswordHasher();
                    var password = passwordHash.HashPassword("Nov04198!");
                    var user = new ApplicationUser
                    {
                        UserName = "thesteve@gmail.com",
                        PasswordHash = password,
                        Email = "thesteve@gmail.com",

                    };

                    manager.Create(user);
                    manager.AddToRole(user.Id, "SuperAdmin");
                }

                context.Accounts.Add(new Account { AccountName = "Seed1" });
                context.Blogs.Add(new Blog { AccountId = 1, Title = "Seed1 Title", SubTitle = "Seed1 SubTitle" });
                context.BlogEntries.Add(new BlogEntry { BlogId = 1, Title = "Seed1 Blog Entry", SubTitle = "Seed1 Blog Sub Title", Body = "Seed data.", Date = DateTime.Now });
                context.Portfolios.Add(new Portfolio { AccountId = 1, Title = "Seed1 Portfolio", SubTitle = "Seed1 Sub Title" });
                context.PortfolioEntryTypes.Add(new PortfolioEntryType { Description = "Seed1 Type", PortfolioId = 1 });
                context.Testimonials.Add(new Testimonial { AccountId = 1, Title = "Testimonials", SubTitle = "Sub Title" });
                context.TestimonialEntries.Add(new TestimonialEntry { TestimonialId = 1, Author = "Paul", Body = "Test Body", Date = DateTime.Now });
                context.Specials.Add(new Special { AccountId = 1, Title = "Title", Body = "Body", Footer = "Footer" });
                context.IndexMessages.Add(new IndexMessage { AccountId = 1, LinkPath = "/Special/", Message = "Check out our specials" });
                base.Seed(context);
            }
        }
    }
}

My Web Config

PaulBinder · Accepted Answer

So , as I stated above, after using a profiler I found that Roles were not correctly joining with Users. This led me down the path to find a way to setup ForeignKeys on Model creation.

  protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {

            Configuration.LazyLoadingEnabled = true;

            var user = modelBuilder.Entity()
    .ToTable("AspNetUsers");
            user.HasMany(u => u.Roles).WithRequired().HasForeignKey(ur => ur.UserId);
            user.HasMany(u => u.Claims).WithRequired().HasForeignKey(uc => uc.UserId);
            user.HasMany(u => u.Logins).WithRequired().HasForeignKey(ul => ul.UserId);
            user.Property(u => u.UserName).IsRequired();

            modelBuilder.Entity()
                .HasKey(r => new { r.UserId, r.RoleId })
                .ToTable("AspNetUserRoles");

            modelBuilder.Entity()
                .HasKey(l => new { l.UserId, l.LoginProvider, l.ProviderKey })
                .ToTable("AspNetUserLogins");

            modelBuilder.Entity()
                .ToTable("AspNetUserClaims");

            var role = modelBuilder.Entity()
                .ToTable("AspNetRoles");
            role.Property(r => r.Name).IsRequired();
            role.HasMany(r => r.Users).WithRequired().HasForeignKey(ur => ur.RoleId);


            modelBuilder.Conventions.Remove();
            modelBuilder.Conventions.Remove();
        }

Now, when pulling users down, their roles come attached. IsInRole works correctly and so does Authorize.

UserManager.IsInRole returns false

Answers (1)

Related Questions