Hi Imar,

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)

Yes, in that case you're absolutely right.... However, that's not the present situation with the PlanetWrox web site.

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!