Another database for login in asp.net mvc

Question

I want to add roles to my website in asp.net mvc 3 so that only an specific role can look at certain controllers.

I read the music store tutorial, and went to the asp .net web administration tool and read that I can customize my provider in the provider tab.

I have in a table called Client from my database and it has columns "Username" "Password" etc. I want to check the login info in these tables.

I went to the provider tab and I can only see AspNetSqlProvider I cannot see a way to add my database there or anything...(the database is already in my project)

How can I configure this. I've search online but haven't found how. Could anyone point me in the direction to do this?

it doesnt seem like you have needs that the default membership provider can't handle. research using that before building your own. even basic things like storing passwords in a database are non-trivial to implement correctly/securely. — Robert Levy
– Robert Levy, Commented Mar 13, 2011 at 5:09

Daniel Liuzzi · Accepted Answer · 2011-03-13 18:13:18Z

1

Microsoft developed a much simpler membership provider called SimpleMembership, that allows you to very easily use an existing database and specify where your usernames/passwords are stored. It was originally introduced for use with the ASP.NET WebPages framework, in WebMatrix, but there already exists a NuGet package that allows you to use it with ASP.NET MVC:

webSecurityService.InitializeDatabaseConnection(
    connectionStringName: "Default", 
    userTableName: "Users", 
    userIdColumn: "ID", 
    userNameColumn: "Username", 
    autoCreateTables: true);

SimpleMembership.Mvc3 NuGet Package

edited Mar 13, 2011 at 18:13

answered Mar 13, 2011 at 9:14

Daniel Liuzzi

17.3k8 gold badges55 silver badges57 bronze badges

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

Comments

Jon · Accepted Answer · 2011-03-13 04:41:57Z

0

You will need to implement a custom membership provider that knows how to check your custom database schema. Here is a video that might get you started. There are heaps of resources online too now that you know the correct terminology to search for ;)

answered Mar 13, 2011 at 4:41

Jon

16.8k8 gold badges54 silver badges62 bronze badges

Comments

GraemeMiller · Accepted Answer · 2012-03-14 22:06:25Z

0

Have a look at Universal Membership Provider Works with SQL Express, Compact, and Azure. Just give it a connection string to your membership DB.

answered Mar 14, 2012 at 22:06

GraemeMiller

12.3k9 gold badges60 silver badges117 bronze badges

Collectives™ on Stack Overflow

Another database for login in asp.net mvc

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related