posted on Friday, July 23, 2004 6:02 PM
by
Benjy
But XSD.exe choked !!!
You know what? I have this strange feeling of deja-vu. Around 18 months ago when i started getting more into XML Schemas and stuff like that, i found that there are problems when you try to load in Xml docs where an element name is duplicated. I found this again when trying to use the Xsd.exe to generate a dataset. [I guess, it isn't deja-vu in that case, merely history repeating itself)
Xsd.exe works fine when generating classes, but not with datasets. I have an element named ADDRESS appearing more than once for things like residence address, office address and all that and XSD.exe didnt like it!!
So is this normal? Should I be going in and changing the element names all over the place? Perhaps we should be designing XSD's where the type name only appears once but the element names are different.
Anyway, I shall try out Irwins suggestion and look at SQLXML again. Maybe I can come up with some graphical tool for generating some of this stuff. It should help.
By the way does anyone know a good explanation why DataSets dont support recursive types? Sometime ago I was working with a nice XML schema which had nested types named PRODUCT. Wanted to persist that into a DB using datasets, but couldnt do it. Wonder if its anything to do with nested tables resulting from such a design.