HI

I've created a database in SQL2008. Two tables with a foreign key relationship.

Then in Visual Studio2008 I'm trying to create a LINQ to SQL Data Model.

I drag the tables onto the design surface but no Foreign key is appearing.

I thought that appeared automatically if the key was defined in the database.

Any ideas what I might have missed.


Thanks

Nick