I am fairly new with ASP (strictly actionscript/flex development at my workplace) and started looking at the MVC stuff. I went through the MVC tutorials and started creating my own test site using the ASP.NET Configuration option to set up login/user/role management. I now have a whole bunch of aspnet_ tables that have relationships already set up, which was very easy. However, I looked at the Users table and it uses a GUID for the userid, but I've never used GUID for a userid field -- I've always used int with incrementing identity.
1) Is it better to use the GUID for userid column, or should I use a separate column that uses an incremental integer? I searched as best as I could and it seemed to be a split opinion. My application is not large (maybe 100 users).
2) The aspnet_ tables seem self-explanitory, but what if I need to add some additional profile info for a user? Say I need to keep track of the user's zip code, address, phone #, etc.... what is the best way to handle/store this data? I'm essentially allowing a user to create their username via the ASP.net membership stuff, but after a user is created, I want to be able to enter additional data into a form that is linked to the new user. So... do I create a new table for profile info and link it to the Users table? Any help or sug
View Complete Post