Edmx missing foreign keys

Question

I am mapping my database using Entity Framework, using the database-first approach.

The problem is that the edmx file that should be mapping my exact database is missing some FK relations between the tables, which causes me to change my queries, because I can't approach the related tables directly.

Of course changing it directly in the classes code, it's erased every time I change something in the database (the edmx is recreated).

I need help please!!!

If you have no alternative but to add the keys manually perhaps try adding them into a custom "partial" class with the same name as the Entity this should stop them getting blown away. — Rob, Oct 11 '12 at 22:30

score 4 · Answer 1 · answered Oct 10 '12 at 08:30

4

When you create the model from the database, there is a checkbox marked "Include Foriegn Key columns In The Model" - Make sure this is checked.

See this article for more info.

answered Oct 10 '12 at 08:30

Rob Hardy

1,821
15
15

2

yes it is checked. someof the Foreign Keys are shown but some just refuse to be shown. – mashta gidi Oct 10 '12 at 08:41
What database are you mapping to? - as in MS-Sql, MySql, oracle etc – Rob Hardy Oct 10 '12 at 08:50

Edmx missing foreign keys

1 Answers1