Skip to main content

Entity Framework Exception - A referential integrity constraint violation occurred

Entity Framework Exception - A referential integrity constraint violation occurred. When you get this type of the exception it just simply means that you need to match Ids of the related entities.

Exception: A referential integrity constraint violation occurred: The property value(s) of 'Image.Id' on one end of a relationship do not match the property value(s) of 'BaseEntity.SomeImageId' on the other end. 

A typical mistake that cause this exception is:

baseEntity.SomeImageId (type of Image)



Does not match.

So if you change the new added related entity to the negative Ids (see the related blog post), then you also need to modify the parent end of the Id (one end of the relationship as Entity Framework expression goes). So that both "ends" have the same Id value.


  1. Have a same problem at here. Thank you! I fixed it for my site Brooklyn Park Web Design

  2. Thanku so much sharing the great information.This problem is always generated in my website web design pune

  3. I have just been experiencing the same issue and the resolution to mine was that I had added mappings to the association and then setup the referential contstraints.

    Inorder to resolve the issue I had to open the mappings window for the association and there was a link to delete the mappings. Once done the Mapping Details window then said Mappings are not allowed.. It appears that adding the referential constraint leaves any mappings in place.

    Thought it may be worth posting in case anyone else is looking for solutions to this error message in the future.

  4. Nutra Trials defines personal characteristics of different health products including skincare, weight loss, muscle and male enhancement. The study presented here is briefly described for reader convenience and to deliver them assurance with health standards. The best possible answers are given here regarding the selection of an ideal supplement or cream or serum that possibly remains to be safe for health and do not cause any side effects.

  5. Machacx
    Get unlimited free tools and cracks for mac os. You can download all premium mac and windows files

  6. TecSmash is your ultimate source of Technology news and Make Money Online product reviews. We research and review all Tech, MMO, Biz Opp and IM products.TecSmash

  7. Healrun is a health news blog we provide the latest news about health, Drugs and latest Diseases and conditions. We update our users with health tips and health products reviews. If you want to know any information about health or health product (Side Effects & Benefits) Feel Free To ask HealRun Support Team.

  8. We are here to give you a complete review on the Parallel Profit project by Steve Clayton and Aidan Booth. If you are someone from the field you would already be familiar with these two names, for those of who are new. Parallel Profits Cost


  9. Pilpedia is supplying 100 percent original and accurate information at each moment of time around our site and merchandise, and the intent is to improve the usage of good and pure health supplement. For More Info please visit Pilpedia online store.

  10. Supplements For Fitness So a new store of healthy foods and supplements opened last week in my local shopping area and yesterday I finally found out. I was impressed with the range of bodybuilding supplements; There were many brands that I have .

  11. Best softwares for Internet Marketers and legitimate make money online opportunities cxyrc


Post a Comment

Popular posts from this blog

How to create new MS SQL virtual machine in Azure

How to create MS SQL virtual machine in Azure and how to enable MS SQL Login user.

1. Create new virtual machine with MS SQL server
2. Open a MS SQL port 1433 in azure management for the given virtual machine
3. Log in to the virtual machine
4. Open port in firewall in virtual machine Windows system - 1433
5. IMPORTANT - Set MS SQL setting to the Mixed Mode (Windows Authentication and SQL Server Authentication) (default is only Windows Auth.)

Entity Framework exception - adding new Detached Object to the DbContext

Entity Framework exception - adding new Detached Object to the DbContext? How to?

When you see this exception:

Exception: Attaching an entity of type 'Image' failed because another entity of the same type already has the same primary key value. This can happen when using the 'Attach' method or setting the state of an entity to 'Unchanged' or 'Modified' if any entities in the graph have conflicting key values. This may be because some entities are new and have not yet received database-generated key values. In this case use the 'Add' method or the 'Added' entity state to track the graph and then set the state of non-new entities to 'Unchanged' or 'Modified' as appropriate.

This just mean that you need to properly handle detanched entities Ids. This exception means that two of your newly added entities have the same Id. Typically the value of the Id is 0.

So the solution is that you need to manually change Ids. You need to …