ADO.NET Entity Framework i cant see Foreign Key Property in Model

Question

Hi i have got 2 table.In first table i got a Foreign Key link to second table's primary key.

(second)Personel and (first)Istbl are my tables.

In personel table i got PersonelID , PersonelName,PersonelSurname.

In Istbl table i got IsID,PersonelID,xx,xx,xx, going like this.

I cant see PersonelID in EF Model Viewer also i cant see it in code screen.

is there any example for me ?

Answer 1

Are you refreshing your datamodel? Have you created the model from the database, if so, try recreating it, if you have updated your database model.

Answer 2

EF v1 hides foreign keys because it views them as persistence artifacts not important to the domain model. See here for a discussion.

EF v2, shipping with .NET 4, will include much better support for foreign keys in the model.

Answer 3

You can get foreign key value with something like this object foreignKey = istblObject.PersonelReference.EntityKey.EntityKeyValues[0].Value;