Modify table Aspnetuserclaims Asp.net Identity

Question

Good morning,

I have a little logic problem with identity.

I need to create an access screen and would like to use the table Claim already made available by it. The big problem is that the table creates a foreign key for the table Aspnetusers, I would like this field to be a foreign key for a table that I will create.

How can I modify this relation between tables?

Answer 1

If you are using ASP.NET Identity, the correct one is your Usuario inherit from IdentityUser:

public class Usuario : IdentityUser { ... }

Table naming settings can be changed through the event OnModelCreating using Fluent API:

public class ApplicationDbContext : IdentityDbContext<Usuario>
{
    public ApplicationDbContext()
        : base("DefaultConnection")
    {
    }

    protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
        modelBuilder.Entity<IdentityUser>()
            .ToTable("Usuarios", "dbo").Property(p => p.Id).HasColumnName("UsuarioId");
        modelBuilder.Entity<Usuario>()
            .ToTable("Usuarios", "dbo").Property(p => p.Id).HasColumnName("UsuarioId");
    }
}

Similarly, this can be done to IdentityUserClaim:

public class UsuarioIdentificacao : IdentityUserClaim { ... }

And the configuration:

        modelBuilder.Entity<IdentityUserClaim>()
            .ToTable("UsuarioIdentificacoes", "dbo").Property(p => p.Id).HasColumnName("UsuarioIdentificacaoId");
        modelBuilder.Entity<UsuarioIdentificacao>()
            .ToTable("UsuarioIdentificacoes", "dbo").Property(p => p.Id).HasColumnName("UsuarioIdentificacaoId");