I am trying to use a one to one (master, detail) relationship in Entity Framework, however, I get this error:

Problem in mapping fragments starting at lines 254, 443:Foreign key constraint 'options_Advanced_FK00' from table options_Advanced (ProductID) to table products (catalogid):: Insufficient mapping: Foreign key must be mapped to some AssociationSet or EntitySets participating in a foreign key association on the conceptual side

Here is the association in the designer:

enter image description here

It says product --> 0..1 options_Advanced

I used model-first and not code first. My Options Advanced table has one product associated with each record

Products

  • ID
  • CatalogID
  • Name

Options_Advanced

  • ID
  • ProductID
  • Name
entity-framework
Edit
Report