Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
VS Express, Database Explorer, DataSet Diagram and Foreign Key Relationship.
golden_eagle
Aug 22 2007 12:22 AM
6.3k
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Database Basics
Search in a Table