Blazor Role Authorization not working

Question

I have a Blazor server application with Identity setup to utilize a SQL Server. Additionally I'm using IdentityManager2 to assist with ensuring the account/roles are setup and everything works properly everywhere except for AuthorizeView and Authorize.

First of all I'm signed in and the index lists my claims. Shown Here:

On my navmenu I have this section:

        <AuthorizeView Policy="@Policies.IsAdmin">  
            <Authorized>  
                <li class="nav-item px-3">  
                    <NavLink class="nav-link" href="admin/user/list">  
                        <span class="oi oi-list-rich" aria-hidden="true"></span> Users  
                    </NavLink>  
                </li>  
                <li class="nav-item px-3">  
                    <NavLink class="nav-link" href="admin/company/list">  
                        <span class="oi oi-list-rich" aria-hidden="true"></span> Companies  
                    </NavLink>  
                </li>  
            </Authorized>  
            <NotAuthorized>  
                <div class="alert alert-danger">not auth</div>  
            </NotAuthorized>  
        </AuthorizeView>  

Additionally I have a page called WaveRiders.razor that contains this line:

@attribute [Authorize(Policy = Policies.IsAdmin)]  

Here is the code in my startup.cs

            services.AddDbContext<SqlContext>(options =>  
                   options.UseSqlServer(  
                       Configuration.GetConnectionString("SqlContextConnection")));  
  
            services.AddDefaultIdentity<IdentityUser>(options => options.SignIn.RequireConfirmedAccount = true)  
                .AddRoles<IdentityRole>()  
                .AddEntityFrameworkStores<SqlContext>();  
  
            services.AddAuthorizationCore(config =>  
            {  
                config.AddPolicy(Policies.IsAdmin, Policies.IsAdminPolicy());  
                config.AddPolicy(Policies.IsCompanyOwner, Policies.IsCompanyOwnerPolicy());  
            });  
  
            services.AddRazorPages();  
  
            services.AddServerSideBlazor();  
            services.AddScoped<AuthenticationStateProvider, RevalidatingIdentityAuthenticationStateProvider<IdentityUser>>();  

So even though I am authenticated and I do belong to the Administrator group it appears I'm always unauthorized and my screen appears as:

I've worked on this issues for at least 10 hours and I'm at the end of trying. Does anyone see what is wrong with the code I provided?

Here is proof from IdentityManager that I belong to the roles:

Answer 1

I'm starting to make progress. I finally decided the code had to be correct since there isn't much code anyway so I looked into the SQL database that I'm using for Identity. I'm leaning to the opinion that IdentityManager isn't doing what it needs to do.

The AspNetRoles contains the roles:

AspNetUserClaim reflects the checkboxes from the IdentityManager application

However the AspNetUserRoles is empty.

If I add the entry manually to the AspNetUserRoles table then the Blazor site works as expected.

Now I have to figure out why the AspNetUserRoles table is not being populate and only the AspNetUserClaim is getting populated when checking the role for the user in IdentityManager.

Maybe IdentityManager isn't the right tool to use??