Abhay Mhatre

Abhay Mhatre

  • NA
  • 29
  • 0

How to create C# class to hold xml data

Aug 14 2008 1:21 PM
Hell everyone,

Here I have 2 design problems.

I want to capture data from xml file and store it into database. I have thought of creating a C# class that will hold every node of xml and them I am thinking of using that class object to move back and forth through out my application. 

#1 . Now my first question is is there any other alternative way that I can use for this kind of work?

#2. I also haven't though of how I am going to store nodes that repeated several times in xml. Let me explain this question briiefly. 

Say I have following xml..

<root>
<family>
    <parents>
       <dad>Wayne</dad>
       <mom>Cathy</mom>
    </parents>
    <children>
       <child gen="boy">Lion</boy>
       <child gen="girl">Nikol</child>
    </children>
</family>

<family>
    <parents>
       <dad>Jiol</dad>
       <mom>Lindy</mom>
    </parents>
    <children>
       <child gen="boy">Michel</boy>
       <child gen="boy">Bob</child>
       <child gen="girl">Carol</child>
       <child gen="girl">Robin</child>
       <child gen="boy">Ryan</child>
    </children>
</family>
</root>


In above xml I can have one column for parents node that is I can have mom and dad column in SQL, but when I go to child the number of occurances are not fixed. In this case how should I create a database table to handle all the possible values....


Please help me put to solve this design problem....

Thank you in advanced.

Abhay Mhatre



Answers (4)