Create class from xml file in c#.net

Question

i have a xml file with following structure,

<TestClass>
  <TestChildClass>
    <TestName Name="sample">
      <Table Name="table1" IdentityColumnName="RollNo" IntColumn="Mark" CharColumn="Name" >
        <Table Name="table2" IdentityColumnName="RollNo" IntColumn="SubjectCode" CharColumn="Subject" ReferenceColumn ="RollNo" >
            <Table Name="table3" IdentityColumnName="RollNo" IntColumn="Average" CharColumn="Subject" ReferenceColumn ="SubjectCode"/>          
         </Table>

        <Table Name="table4" IdentityColumnName="RollNo" IntColumn="Rank" CharColumn="Name" />
      </Table >
    </TestName >    
  </TestChildClass>
  </TestClass>

i have created a class for the above xml using XSD.EXE. But the thing is when i tried to create object for the new class named TestClass.cs then its throwing error like "The same table 'Table' cannot be the child table in two nested relations." How to solve this?

That's not an XSD file, you can't generate a class from it, because you can't be sure of everything about the definition from one example XML file. If you know all the details, you can manually write the corresponding classes. — Tim S.
– Tim S., Commented Oct 9, 2012 at 11:58
From the XSD cmd line: <instance>.xml Name of an xml file to infer xsd schema from. — Henk Holterman
– Henk Holterman, Commented Oct 9, 2012 at 12:40
ya.. i have created those classes. When i am trying to create instance for that created class it shows error — Tanya
– Tanya, Commented Oct 9, 2012 at 12:51

Matt Smucker · Accepted Answer · 2012-10-09 13:58:17Z

1

Your XML is not valid, you need to remove the lines and make sure to close the node for Table1

<TestClass>
  <TestChildClass>
    <TestName Name="sample">
      <Table Name="table1" IdentityColumnName="RollNo" IntColumn="Mark" CharColumn="Name" >
        <Table Name="table2" IdentityColumnName="RollNo" IntColumn="SubjectCode" CharColumn="Subject" ReferenceColumn ="RollNo" >
            <Table Name="table3" IdentityColumnName="RollNo" IntColumn="Average" CharColumn="Subject" ReferenceColumn ="SubjectCode"/>          
         </Table>
        <Table Name="table4" IdentityColumnName="RollNo" IntColumn="Rank" CharColumn="Name" />
      </Table >
    </TestName >    
  </TestChildClass>
</TestClass>

edited Oct 9, 2012 at 13:58

answered Oct 9, 2012 at 13:02

Matt Smucker

5,2442 gold badges24 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Tanya Over a year ago

But the Table2 is the child table of the table1. And table3 is the child table of table2. Table4 is the again the child table of the table1. for that only i have added the xml like that.

Matt Smucker Over a year ago

Then you need to remove the /> at the end of table1 and table2, and replace them with >. That should make the XML well formed, but it may still fail the XSD class generation

Tanya Over a year ago

ya.. that is what i have added in my question. please Checkout

Matt Smucker Over a year ago

It's still not well formed, you're not closing TestChildClass or TestClass

Tanya Over a year ago

oh.. sorry i missed "/". but even it is showing the same error

|

Collectives™ on Stack Overflow

Create class from xml file in c#.net

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related