How can I add an FK constraint to my entity model without adding it to the DB?

Question

I have an Entity Framework model with table Employees. Each employee has a SupervisorId, which points to another record in the same Employees table. The entity model VS inferred from my DB design looked fine, but I could not update or insert records for the table with the self-reference. I have taken to using a view of the Employees table for the Supervisors table, but I cannot add an FK constraint to a view in the database. How can I do this, or achieve the same effect, in the EF designer?

At worst I can skip the FK constrain, but would like to know how to use and populated a standard or custom combobox so the Employee form still offers a choice of Supervisors when editing.

Answer 1

I have the same problem. The Association is added, but I can't add foreign key to the entity