Entity Framework 5.0 1:1 relationship Model-First

Question

Possible Duplicate:
1:1 relationship problems with EF Model First

Is there a way to define 1:1 relationships on a Entity Framework .edmx without get this annoying:

Error 1 Running transformation: Multiplicity is not valid in Role 'PESSOACPF' in relationship 'FK_CPF_PES'. Because the Dependent Role properties are not the key properties, the upper bound of the multiplicity of the Dependent Role must be *.

Already defined the FK as PK on my table, removed the pk, tried to re-create the project over 10 times and doesn't help AT ALL.

Are you on EF 5? Yes, they are connected. Yet EF loves to do 1:* relationships. — user1695928, Dec 24 '12 at 21:46
Looks like EF is bugged. I removed one of the PK's and it worked. That way i cant — user1695928, Dec 24 '12 at 21:47
Yes, but I'm doing code-first (it's same behind the scenes). I do not have access to VS here, so will not be able to verify. — SWeko, Dec 24 '12 at 21:48

score 2 · Accepted Answer · edited May 23 '17 at 12:26

Your Foreign Key must be defined as UNIQUE.

To enforce a 1:0 or 1:1 relationship.

You can create Table in SQL DB like this (Lets take Order and OrderDetails Tables)):

CREATE TABLE OrderDetails (
    DetailsId INTEGER IDENTITY NOT NULL,
    orderId INTEGER NOT NULL UNIQUE,
    PRIMARY KEY (DetailsId),
    FOREIGN KEY (orderId) REFERENCES Order(orderId)
)

For more details Implementing one-to-zero-or-one relation in SQL Server

I hope this will help to you.

Entity Framework 5.0 1:1 relationship Model-First

1 Answers1