Noticed reduced functionality on mysql dataset on vs2010 after moving the db to the development server. Then trying to create a dataset. The dataset no longer showed references. Is there a way to solve this so that the referential integrity exists between tables when dropping respective tables onto the dataset design surface using a db on the godaddy.com's mysql data store?
The image attached shows that referential integrity was fine if the mysql db is on the development system. But after moving the db to the go daddy system, the db no longer showed referential integrity after dropping tables on the design surface of the dataset.