Chapter 17: UserName Column in PhotoAlbum table
In the Try it out "Letting Users Manage Their Own Photo Albums" (Chapter 17) the column "UserName" is added to the database.
But doesnt this username column contain redundant data because usernames are already stored in the aspnetdb database (table aspnet_Users) ?
In a production environment wouldnt it be better to add on only a "UserID" column to the PhotoAlbum table and create a foreign key to the the UserID column in aspnetdb? (assuming both tables are in the same database)
Last edited by ibmkahm; November 5th, 2010 at 07:29 AM..