How to integrate ASP.NET Identity tables in an existing database

Question

Using Asp.net 4.5 and VS 2013, I would like to know how to integrate Asp.Net Identity Tables with an existing database.

So basically I would like to have db tables for Identity and my own tables in the same db.

I know Asp.Net Identity use Code First approach but I would like to use DB first approach for my existing db. I am little confuse.

How would you handle this?

Does it make sense keep Asp.Net Identity Tables in a different database that my own Tables?

Community · Accepted Answer · 2017-05-23 11:46:13Z

2

I think that depends preety much on what you want to achieve.

Is it a single asp.Net application that you are developing or a set of different apps that would use the same database?

Here there is an answer I pretty much agree with. Separate schema and one database for one app/database. Two databases kind of beat the point of separation but three databases might be a better solution if the authorization rules remain the same.

As for the DB first approach there is a pretty good article (and code) here.

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Nov 23, 2013 at 16:52

Athanasios Kataras

26.7k6 gold badges40 silver badges67 bronze badges

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

1 Comment

Dieglock Over a year ago

Can the original question of the title be answered? In this voted answer, is the last question, about one or two servers, being answered. But not the one in the title. I will like to have my IdentityUser tables in the already working database. Can someone answer that, please? DB First approach does not cover that. I made another question: stackoverflow.com/questions/38082443/…. Thanks.

Gcobani Poswa · Accepted Answer · 2017-02-27 12:15:02Z

0

Edit your identitymodel to override model creation and point to your existing tables you have set-up

        protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        modelBuilder.Entity<IdentityUser>().ToTable("Users");
        modelBuilder.Entity<ApplicationUser>().ToTable("Users");
        modelBuilder.Entity<IdentityUserRole>().ToTable("UserRoles");
        modelBuilder.Entity<IdentityUserLogin>().ToTable("UserLogins");
        modelBuilder.Entity<IdentityUserClaim>().ToTable("UserClaims");
        modelBuilder.Entity<IdentityRole>().ToTable("Roles");
    }

answered Feb 27, 2017 at 12:15

Gcobani Poswa

212 bronze badges

Collectives™ on Stack Overflow

How to integrate ASP.NET Identity tables in an existing database

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related