Hi -

I got this message on Chapter 15 exercise "Cannot insert explicit value for identity column in table 'Review' when IDENTITY_INSERT is set to OFF." If I tried to change the Identity Specification to NO - but, I got this message "Violation of PRIMARY KEY constraint 'PK_Table2'. Cannot insert duplicate key in object 'dbo.Review'. The statement has been terminated."

I tried also the following:

1. Delete the tables from the EF diagram and add them again.
2. Select the Id column in EF designer and open its Properties Grid (F4). Then set StoreGeneratedPattern to Identity, save your changes and try again.
3.; Try to update the model. Right-click the design surface of the EF diagram and choose Update Model from Database and follow the on-screen instructions.

All are to no avail.

Appreciate help

Jorgen

Hi there,

You need to set (Is Identity) to all Id columns in the tables in the database. After you've modified the database, you need to recreate the EDMX model again. Delete all tables from the EF diagram (and confirm you want them deleted from the underlying model as well) and then add them again.

Worst case, you need to start with a new diagram. If you try that out, first remove the PlanetWroxEntities connection string from web.config to avoid issues with duplicate connection strings.

If all this still fails, there may be something in your code that tries to set the ID explicitly, In that case, post the code (markup and code behind) of the relevant pages here.

Hope this helps,

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!