ADO.NET Entity Association problem

Question

hi , i got Two Table named Personel and Departmant..

Personel Table ; PERSONELID int , PK not null NAME varchar SURNAME varchar DepartmanID integer

Departman Table ; DepartmanID int , PK not null DEPARTMANNAME varchar

(ONE TO MANY Relation)

i wanna association between this tables. but i cant do it. with EDMX Model Designer .. gettin errors ;

Association END KEY property PERSONELID is not mapped. Association END KEY property NAME is not mapped. blabla ....

too new at this framework , Is there any easy way of do this job in the Entity Framework , ?

i am using Firebird 2.1 DB . and Firebird.Client.Data 2.5.0.0. for provider.

Answer 1

For a one-to-one relationship to work each table must have the same primary (unique) key.

In your case you probably have a one to many relationship:

One department can have many persons.