I am updating my database and changing the FK constraints on the fly. VS2008 does not seem to see those changes immediately nor allow me to easily update the dbml file. Even a refresh to the Server Explorer in VS2008 does not get constraints.
I refresh and drag and drop the tables in question onto the dbml file in VS2008, but it has no affect even though SQL Server Management studio shows the FK constraints on the tables! Its as if the tables are cached in VS2008.
The problem will go away if I do these steps
1) Build the project with the tables not showing the foreign key constraints.
2) Remove tables in question.
3) Drag/Drop the tables back to the dbml file.
Wala....the links are there...why? Note my links are 1 to many.
I expect to not have to build to solve this issue, and that a refresh to the SQL server explorer in VS2008 should be enough. I understand I need to delete the *old* tables from the dbml file, but don't have me build...it seems counter intuitive to have to build visually wrong tables, then delete and re-add when the re-add should be enough.