Chapter 14

olias · May 3rd, 2011, 11:34 PM

Hi Everyone

I am working on the second try it now section in chapter 14 where I encounter an error at step 16 - (Save all your changes, close all open files, and then request NewPhotoAlbum.aspx). When I insert a name and click 'Insert' I get a ASP.NET yellow page of death that states "Object reference not set to an instance of an object"

When I place a break point (*) at:

Code:

protected void EntityDataSource1_Inserted(object sender, EntityDataSourceChangedEventArgs e)
  {
   (*) PhotoAlbum myPhotoAlbum = (PhotoAlbum)e.Entity;

At this point e is null and when I drill down to find more information I find the following exception:

InnerException = {"Cannot insert explicit value for identity column in table 'PhotoAlbum' when IDENTITY_INSERT is set to OFF."}

How can I set this property from VS 2010? Has anyone else received this error?

I would greatly appreciate anyone's help.

Thanks,

Imar · May 4th, 2011, 03:35 AM

Hi there,

Take a look at Step 1 of the exercise at page 498. It shows you the table definition and explains how to make the Id column an identity.

After you changed the database, you need to update the EF model. You can right-click the design surface and choose Update model from database and follow the wizard. Alternatively, you can delete the tables from the EF diagram and add them again.

Hope this helps,

Imar

olias · May 4th, 2011, 12:38 PM

Thanks Imar

That did it!!

This is a great book, I am really enjoying it!!

Imar · May 4th, 2011, 12:42 PM

Quote:

This is a great book, I am really enjoying it!!

Thank you! Have fun with the remaining chapters.

Cheers,

Imar