Creating Strongly Typed Datasets in VS.NET
Posted: Sun 08 Jan 2006 14:36
I have a fully constructed MySQL db, and I'm trying to create a stronlgy typed dataset in VS2003 from it.
Usually I'd create some data adaptors for each table, then choose 'Generate Dataset' from one of them, and then select all the data adaptors, and point them to an empty xsd file.
However, when I try to do that with CoreLabs software, I only get one table in my XSD. If I try to do one at a time, it always overwrites the previous one !
Ideally - I should be able to drag a table from the dbExplorer to my XSD file - but that's not permitted either! Is there an easy way to create an XSD from an existing mySQL db?
Thanks all,
AndrewG
Usually I'd create some data adaptors for each table, then choose 'Generate Dataset' from one of them, and then select all the data adaptors, and point them to an empty xsd file.
However, when I try to do that with CoreLabs software, I only get one table in my XSD. If I try to do one at a time, it always overwrites the previous one !
Ideally - I should be able to drag a table from the dbExplorer to my XSD file - but that's not permitted either! Is there an easy way to create an XSD from an existing mySQL db?
Thanks all,
AndrewG