Hi all,
I'm trying to convert an ASP application to a .NET one. In the old ASP application methodology we have a "users" database with all our users and is indexed by an auto-increment integer which is used across our database (~25-30 tables) relationally. I'm recreating the tables from scratch, so no need to worry about merging data. Let's assume we just have a large relational database that we want to connect to the .NET security model.
Now - with .NET, there is the concept of members and roles being handled for you. I took a look at the aspnet_Users table and it shows a GUID for members I created using the ASP.NET Configuration tool. Basically I need advice on how to link the ASP.NET user's login to my custom database. Any tutorials/links are welcome, I'm not afraid of reading!
It would be great for the Context.User.Identity.Name to store the auto-increment integer PK as well because that could be used in all of my SQL querie ...
Go to the complete details ...