0

I've just started with MVC after working on Web Forms for 4 years. I've watched few videos explaining the architecture/fundamentals and I'm now able to replicate few modules of my old project with MVC5 using EF6.

I've a SQL Server DB containing tables such as Albums/Artists/Titles/Reviews and he User Table. I was able to work with the first set of tables using EF6 just fine including inserts/deletes. The prev project I had implemented custom Web Forms authentication using BCrypt by storing the details in the User table and later doing the validations and setting the auth cookie.

User table has details such as UserId, PWHash, EMail, FirstName, LastName. The UserId is a FK in the Reviews table and few others.

The implementation I'm hoping for is as below:

  1. Login screen accepts credentials and validates with existing User table.
  2. If valid, move to the 2FA screen(eMail/SMS).
  3. If valid, then allow access to application.

Most of the tutorials say how to extend the attributes such as FirstName/LastName but do not say how to use an existing DB. I'm planning to use bcrypt/scrypt to encrypt the sensitive details.

I've gone through MVC 5 & ASP.NET Identity - Implementation Confusion but id doesn't have all the answers to my queries

I just need the starting point on how to plug the existing DB instead of using the dbcontext provided by default

Community
  • 1
  • 1
Dev
  • 987
  • 2
  • 14
  • 32

2 Answers2

1

Personally I find the documentation quite frustrating as well when you move away from th conventional, so you may be in for a world of pain.

The easiest way would be to fully take control of the authentication process yourself, utilising FormsAuthentication

However, if you want to leverage a lot of the out the box code, that has been delivered with MVC5 but against a custom database, or schema you will probably have to implement your own UserStore and maybe UserManager among other things.

The problem is, there is a lot to implement, so you are going to have a fun time guaranteed.

Have a read through this article on Custom Storage Prodivers to get a head start.

Good luck

shenku
  • 11,969
  • 12
  • 64
  • 118
0

If your app is using EF Code First then you can use your existing schema and plug in your own user. Look at the following example which shows how you can reuse your existing user information and plug it into Identity http://aspnet.codeplex.com/SourceControl/latest#Samples/Identity/CustomMembershipSample/Readme.txt

You do not have to inherit from the IdentityDbContext. You can directly use the DbContext. In this case you will have to override the onModelCreating to create the Users/ Roles tables and all the mappings between the tables.

pranav rastogi
  • 4,124
  • 23
  • 23