Cannot use table 'AspNetRoles' for entity type 'AspNetRole' since it is being used for entity type 'IdentityRole' and potentially other entity types, but there is no linking relationship.

File a bug

I am using Db first approach using latest EF version in DOTNET 6. It does not generate AspNetUserRole table and add dictionary details as

modelBuilder.Entity<AspNetUser>(entity =>
    {
        entity.HasIndex(e => e.UserName, "UserNameIndex")
            .IsUnique();

        entity.Property(e => e.Id).HasMaxLength(128);

        entity.Property(e => e.Email).HasMaxLength(256);

        entity.Property(e => e.LockoutEndDateUtc).HasColumnType("datetime");

        entity.Property(e => e.UserName).HasMaxLength(256);


        entity.HasMany(d => d.Roles)
            .WithMany(p => p.Users);
    .UsingEntity<Dictionary<string, object>>(
        "AspNetUserRole",
        l => l.HasOne<AspNetRole>().WithMany().HasForeignKey("RoleId").HasConstraintName("FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId"),
        r => r.HasOne<AspNetUser>().WithMany().HasForeignKey("UserId").HasConstraintName("FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId"),
        j =>
        {
            j.HasKey("UserId", "RoleId").HasName("PK_dbo.AspNetUserRoles");

            j.ToTable("AspNetUserRoles");

            j.HasIndex(new[] { "RoleId" }, "IX_RoleId");

            j.HasIndex(new[] { "UserId" }, "IX_UserId");

            j.IndexerProperty<string>("UserId").HasMaxLength(128);

            j.IndexerProperty<string>("RoleId").HasMaxLength(128);
        });
    });

Now, when I am trying to use Microsoft.AspNetCore.Identity.EntityFrameworkCore method to get user details using FindByLoginAsync method. I get the error

My Program.cs is configured as:

I also tried by manually adding the table AspNetUserRole and adding the relationships as

Please download the project from https://drive.google.com/file/d/14zmk-jijpYPbyzwOkJ63OPBMM44CHkSY/view?usp=sharing

I would be grateful if you help as ASAP. Thanks

Include provider and version information

EF Core version: 6.0.1 Database provider: (e.g. Microsoft.EntityFrameworkCore.SqlServer) Target framework: (e.g. .NET 6.0) Operating system: IDE: (e.g. Visual Studio 2019 16.3)