Invalid Key node inside constraint error

[Guest]

I have an XML document that I'm reading into a dataset. I programmatically
created dataadapters and constraints for all the tables and relationships and
I'm able to insert all the data into the database no problem. Instead of
running the code to create the constraints all the time, I used
WriteXMLSchema to write out an .xsd for me that has everything already
defined. Now when I read this schema back using ReadXMLSchema, I get the
error:

Invalid 'Key' node inside constraint named: Arrests-Inv_Holding_Facilities

..NET created this .xsd for me, why can't it read it in? I've made no
changes to it manually. I've seen several messages with this same question
out on the web, but no answers. Can anyone tell me what the problem is?

 

[Guest]

I found the answer myself. Evidently ReadXMLSchema doesn't like it when you
read in the XML before you read in the Schema. : ) Read the schema first
and no problems.

 

[Sahil Malik [MVP]]

Actually the problem is slightly different.

The XML Document that you read *before* - has data that is inconsistent with
the schema.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/