When using the membership provider I noticed that the UserID is a GUID and not an int indentity.
I dont have much experience with DB's but Im used to using Int as the primary key for tables that contain "Users". In particular it makes for cleaner URL's, its easier to debug the DB, and Ive read that working with ints is faster than using GuID
Q1: Do you forsee any major problems in the future if I change the database tables and stored procedures so that 'UserID' uses type Int.
This DB will be used for a web app that could be classified as "social networking".
Q2: whats the best practice for the following scenario. Lets say "jack" is at "Jills" profile page on a social networking site. Jack adds "jill" as a contact.
ok, with repect to databases, in order to complete this task I will need a reference to&n ...
Go to the complete details ...