VS Express, Database Explorer, DataSet Diagram and Foreign Key Relationship.

Aug 22 2007 12:22 AM
Hi there,

I've created a database using the database diagram and database explorer. Setup the foreign key contraints and the delete and update rule.

From here I've created a dataset by dragging the tables and views from the database explorer onto the dataset diagram.

This all works find except that the foreign key constraints are not being transfered over. I would expect that there would be foreign key contraints with update and delete rules (as was setup in the database diagram) however all the table relations are Relation Only.

Is this a limitation of VS Express or am I doing something wrong.

Regards,
Edwin.

Answers (2)