Entity Framework Foreign Key Issue

Question

I am getting a very frustrating issue:

System.Data.UpdateException was unhandled by user code
Message="Entities in 'MyProjectEntities.GroupingData' participate in the 'FK_GroupingData_AuditTrail' relationship.
0 related 'AuditTrail' were found. 1 'AuditTrail' is expected."

This happens when I try to add an object to the database in the GroupingData table. Every other table where I do inserts it's fine.

Furthermore, my EDMX properly reflects my database. I am dumbfounded. If any one has faced a similar situation in the past, I would like some advice.

Answer 1

Make the relationship MyProjectEntities.GroupingData -> AuditTrail to 0..1 - * perhaps?