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 cod ...
Go to the complete details ...