Good Morning, all. Happy New Year..
I am building a DevForce Silverlight app and am getting the following error upon save:
"The Changes to the database were committed successfully, but an error occurred while updating the object context. The object might be in an inconsistent state. Inner Exception: A circular relationship path has been detected while enforcing a referential integrity constraints. Referential Integrity cannot be enforced on cicular relationships"
I'm trying to track this issue down. Please note: this application before using DevForce (using stored procedures) was working fine with no referential integrity errors.
The only thing I can see which *might* be an issue is the part of the Record table.
A Record contains information about a "trouble ticket" (think 'help desk'). The Record has associated tables like a RecordService (which holds a list of all the Services provided with an instance of the Trouble Ticket).
A person gets a Service provided at a specific Location. The Services and Location combination is stored in a ServiceLocation table.
I have the person taking the record pick an entry from the ServiceLocation table, but I record the Record Service with an entry to the Record, Service, and Location (as opposed to a ServiceLocation).
Code:
recordservice.Active =
true;
recordservice.Record = _record;
recordservice.Service = SelectedServiceLocation.Service;
recordservice.Location = SelectedServiceLocation.Location;
Any hints as to how / where to troubleshoot and (more importantly) how to correct this? A search of the Wiki doesn't yield anything about Circular References.