User authentication using Entity Framework in ASP.NET MVC 3

Question

I have an enter image description here exisiting database which I used to create a Model usign the Database first approach. Please refer to the database diagram.

In my solution file, I have a Class Library of the model which has an ADO.NET connection to the database & and I a ASP.NET MVC 3 web application.

The funcitonality that I'm trying to get here is that - the information displayed once a user logs in is different for every user. How do I link the user login page to the 'user' table of the database? Is it directly using the connection string or do I need to go through the model that I created using the Database?

Erik Funkenbusch · Accepted Answer · 2012-01-27 00:59:59Z

1

Add a field to your User table called "ProviderUserKey" or MembershipUserID, or something similar of type uniqueidentifier. You then call Membership.GetUser().ProviderUserKey and use that in your where clause of your User Table to select the correct User record based on the logged in user.

answered Jan 27, 2012 at 0:59

Erik Funkenbusch

93.7k29 gold badges201 silver badges292 bronze badges

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

6 Comments

wackytacky99 Over a year ago

That is right, but how do I link the user login view with this user table for user authentication?

Erik Funkenbusch Over a year ago

@mvador99 - I don't understand. What does your table have to do with user authentication? Authentication is handled by the Membership system, and has nothing to do with your table. Or do you mean you want to use your table instead of the asp.net membership tables? If that's the case, then you need to write a custom membership provider.

wackytacky99 Over a year ago

Yes I want to use the User table instead of the Membership tables. What do you mean by a custom membership provider?

Erik Funkenbusch Over a year ago

@mvador99 - I mean, create a custom membership provider. msdn.microsoft.com/en-us/library/ie/f1kyba5e.aspx

wackytacky99 Over a year ago

Can I use the regular Membership provider and then use the User table to store additional information? If yes, will that allow me to filter the SalesOrders and other records by user?

|

Collectives™ on Stack Overflow

User authentication using Entity Framework in ASP.NET MVC 3

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related