Changing default database of Identity/Membership authentication in ASP.NET MVC 5.1

Wellington Zanelli picture Wellington Zanelli · Jun 17, 2014 · Viewed 9.8k times · Source

I currently started a new project in Visual Studio 2013 with ASP.NET MVC5 using Entity Framework Model-First. With entity is all fine, by now... haha

My question is: There's any way to change the database of Identity without overwriting it?

Explaining better: Currently, my database generated from Entity is well in my external SQL Server database, but my account information is in (I guess it) the SQL Server that run with Visual Studio 2013.

Reinforcing it: I just want to change the database to be the same as my Entity Framework is using, I don't want to overwrite it. Is it possible?

Answer

pranav rastogi picture pranav rastogi · Jun 23, 2014

You have to change the ConnectionString to point to the database that you want. Identity uses EF to create the database and schema. Alternatively you can pass in the ConnectionString of your EF database to the IdentityDbContext. For example, in this sample, DefaultConnection is the name of the ConnectionString used by my EF Context and Identity Context:

public class MyDbContext : IdentityDbContext<ApplicationUser>
    {
        public MyDbContext()
            : base("DefaultConnection")
        {
        }
    }