There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
EF 4 Designer Doesn't Show Chinook 1.3 MSSQL Relations
Not sure whether this is a Chinook issue or Entity Framework issue...
I got Chinook 1.3 from the releases, installed the MSSQL one on MSSQL 2008 Express, created a new .NET 4 project, Added Entity Framework 4 EDMX item, chose to generate from database and pointed to the previously mentioned DB.
It got all tables correct, but not any of the relations.
I tried enforcing some relations and / or setting update/delete to Cascade instead of None and deleting the corresponding tables (both ends) and re-adding them to model. No relations showed still.
The relations are in the DB and I can see and modify them as above and even can see them clearly in SQL Server diagram, but not in EF Designer (nor of course generated classes).
Any idea what could be the trick? (Sorry if EF-only question - Just wanted to see if you are aware of the issue, since it felt pretty straight forward exercise).