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: