MVC5 Login to custom Database

Question

What if you have your own database and a BAL (Business Access Layer) and don't want to use DefaultConnection and the template ASPNET database tables but my own user tables?

How can you use a custom database?

ConnectionString:

public class AppDbContext : IdentityDbContext<AppUser>
{
    public AppDbContext() : base("DefaultConnection")
    {
    }
}

Web.config

<add name="DefaultConnection" 
   connectionString="Data Source=(LocalDb)\v11.0;
                     AttachDbFilename=|DataDirectory|\NakedIdentity-Mvc.mdf;
                     Initial Catalog=NakedIdentity-Mvc;Integrated Security=True" 
   providerName="System.Data.SqlClient" />

Answer 1

You can customize your tables, your storage and your classes.
The process is not straightforward but with a little bit of work you can do that. I've answered a similar question few days ago.
You can find it here.

You can find a project on github where I've tried to customize all the tables involved in the authentication/authorization process.

This is another answer where you can read something more about using a different storage for your users and roles.

Answer 2

You can always specify database which you want to talk - this is actually idea of connection string configuration. You need to change connectionString attribute in that way that will point to your desired DB.

Here is good source of information about connection strings