I'm creating a separate table in a one-to-one relationship with the aspnet_Users table in order to store additional user information (instead of using the non-relational default profile system). What I'm trying to figure out is if it's better to use the username or the userid as the foreign key? I recently read something in a comment by Scott Guthrie suggesting to someone that they should use the username as the foreign key (I'll post the link if I can find it again). Originally I was thinking to use the UserId 100%, but then it seems like the username could perform the same job equally well. (I already put a unique constraint on the username column) Thoughts?
...
Go to the complete details ...