Missing associations when building a model from existing SQL server database

Question

Edit: the issue is solved in the newer versions of EF. At least that's what I assume since I recently created a new project and followed the same steps and everything went fine! Thanks for your comments and helps. I leave the original question, untouched, below.

I'm using the Entity Framework for the first time. I have a strange problem: I have this small database on SQL Server. Here is the diagram from the management studio:

As you can see, the foreign keys are all defined. To generate the edmx model, I selected "New Item -> ADO.NET Entity Data Model -> Generate from database". This is what I get:

All associations but two are missing! This is odd since the good old L2S could recognize them with no problem:

Can anybody help me fix it?

Answer 1

The answer to our problem in this case is that we had Unique Non-Clustered Index on some of the primary keys - this caused a problem for the EF model (but not in Linq2SQL). Changing the indexes on these keys to Unique Clustered Index fixed the problem!

Answer 2

Are you checking the option of "Include foreign key columns in the model"?

_{(source: msdn.com)}