tags:

views:

21

answers:

0
Q: 

A referential integrity constraint violation occurred

Hi All, I have a entity model and on it i have a object with name Person that this object have 1 ti 1 relation with NaturalPerson and LegalPerson. therefore the Person is a abstract class and Naturalperson and LegalPerson inherited from Person, but when i try to add NaturalPerson in DAL i got this error

A referential integrity constraint violation occurred: A primary key property that is a part of referential integrity constraint cannot be changed when the dependent object is Unchanged unless it is being set to the association's principal object. The principal object must be tracked and not marked for deletion.

any idea, or any idea to implement this relationship

related questions

How do you model roles / relationships with Domain Driven Design in mind?
Need help with ADO.NET Entity Framework UpdateException.
Automatically update Last Modified Date in ASP.Net MVC app
Going from 2 to many in Rails
Database Design Problem
2x one-to-many relationships in OO
How to eagerly fetch a single "default" entity from a collection in EJB3/JPA
MySQL: Finding rows that don't take part in a relationship
What is the best way to represent a many-to-many relationship between records in a single SQL table?
Entity Framework - how do I use the entity relationships in my extended classes?
Entity Framework - how do I use the entity associations?
Best relationships between one table and some other tables, each of them depending on n datasets of the first table?
How to deal with a Many-To-Many Relation in my API
How to define structure in a tag-based organization?
Same fields in most tables
Entity Relationship Diagram for MS Access
Customized naming of columns in JPA relationships
JPA - many to many relationship of a table with a compound-key with itself
Generate an E-R Diagram by reverse-engineering a database
How to combine cascading updates/deletes between SQL Server and NHibernate?
Database schema to track random settings in website for marketing
CakePHP hasAndBelogsToMany using save() vs. saveAll()
CakePHP multi-model view
Many to Many Relationship in MS Dynamics CRM 4.0 - How to?
Suitable E-R notation for introductory DB design course? Good/free diagram tools?