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.
Loading
golden_eaglePosted Aug 24, 2007, 2:34 AM
I've gotten that far (creating the database diagram with tables and foeign key constraints).
However when dragging the tables on to the DataSet Diagram I seem to lose the foreign key constraints. On the DataSet the relations are "Relation Only" without the update and delete rules.
Regards,
Edwin.
Munir ShaikhPosted Aug 23, 2007, 5:00 AM
You are right to have foreign key you need to create digram in the database and add the tables to it and set relation.
Regards,
>>Munnamax