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 queries to grab information for given users. Any ideas on how to do this?Thanks very much! Hope to hear from you soon.-Mikep.s. I'm trying to write it as an MVC2 application with a lot of Linq to SQL to keep it all strongly typed and awesome.
View Complete Post