How to create my own table using EF in asp net core identity

Question

Currently, I have EF working perfectly fine with asp net core identity. My web app allows users to login in 2 ways: using their local account and using their azure active directory account. However, only the allowed azure directory accounts are allowed to log in. Therefore, I need to create another table to hold those accounts to cross check when they log in.

Brando Zhang · Accepted Answer · 2022-09-01 02:07:11Z

1

If you want to create a new table for the Identity project, I suggest you could try to modify the identity EF's dbcontext with the new create model class.

More details, you could refer to below codes:

public class UserRelationship
{

    public int UserId { get; set; }
}

Modify the ApplicationDbContext :

public class ApplicationDbContext : IdentityDbContext
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
        : base(options)
    {
    }

    public DbSet<UserRelationship> UserRelationships { get; set; }
}

Then you could enable the migration and update the database like this article shows.

answered Sep 1, 2022 at 2:07

Brando Zhang

29.1k6 gold badges42 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hoang Minh Over a year ago

Thanks. I ended up using exactly same approach that you proposed :)

Collectives™ on Stack Overflow

How to create my own table using EF in asp net core identity

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related