I have an XML schema for JobPositionPosting (from www.hr-xml.org). If I give
this to XSD.EXE as input and tell it to generate classes, I get a 1500-line
..cs file containing approximately 70 class definitions. These correspond to
the nodes in the tree defined by the schema. The actual data elements are
fields in the classes.
The data source to be used for creating objects is a legacy RDBMS (not
SQLServer), with no XML support. So basically I execute a SELECT statement
and get back a table/dataset with fields that need to be mapped to the nodes
in the tree defined by the schema.
This is easy to do "by hand" for trivial cases, the kind used as examples in
books. For this real-world case I would like to have some kind of algorithm
for matching the table fields to the class fields. But I'm having trouble
finding one, or a tool for generating one. I'd appreciate any pointer to
examples or tools.
Mike Carroll
Sigma Data Systems, Inc.