The {0} is used in the string.Format call. Consider this:
Code:
string.Format("ManagePhotoAlbum.aspx?PhotoAlbumId=(0)", myPhotoAlbum.id.ToString())
This creates a string with a redirect URL based on the ID of the new photoalbum. So, if you insert a record in the database (you still haven't confirmed whether the record shows up in the database or not) its new ID is taken and appended to the redirect string. String.Format nicely puts the ID at the place of the {0} placeholder. So, when your new Album has an ID of 34, you're redirected to:
ManagePhotoAlbum.aspx?PhotoAlbumId=34
After you changed your database schema (column names etc) did you also regenerate the Linq to SQL diagram? And is your ID column a primary key AND an identity?
Imar