Configure database for MVC authentication

Question

I've been Googling terms like

configure database for mvc authentication

But I can't find anything from this decade that relates to my configuration.

I've created an MVC application using .NET Framework 4.6 with authentication support (database first). Now where do I find step-by-step instructions for creating the database tables and configuring MVC to use them?

Thanks for any tips!

You can start here: asp.net/identity/overview/getting-started/… — trailmax
– trailmax, Commented Feb 2, 2017 at 2:12
@trailmax: Thanks, been reading there now. Too bad some of the articles are so old though. And the only example I've found so far assumes you are using Azure. — Jonathan Wood
– Jonathan Wood, Commented Feb 2, 2017 at 17:27

Andrew Shepherd · Accepted Answer · 2017-02-02 01:47:52Z

1

The correct thing to google for is 'ASP.NET Identity'.

If you generate an MVC app straight from one of the templates it will generate a number of classes to handle security and identity.

One of these classes will implement interface IUserStore. The class provided will inherit from Microsoft.AspNet.Identity.EntityFramework.UserStore<TUser>, and uses Entity Framework to check the database if the tables exist, and create them if they are not there.

If you are uneasy about giving your application enough privileges to modify your data schema (ew!), you can create your own class that implements IUserStore and plug that into the system.

It's a big topic, but hopefully this is enough to get started with.

edited Feb 2, 2017 at 1:47

answered Feb 2, 2017 at 1:36

Andrew Shepherd

45.5k33 gold badges148 silver badges212 bronze badges

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

Collectives™ on Stack Overflow

Configure database for MVC authentication

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related