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..
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
Abhay MhatrePosted Aug 14, 2008, 8:35 PM
Muhammad Shahid FarooqPosted Aug 14, 2008, 7:46 PM
Abhay MhatrePosted Aug 14, 2008, 7:13 PM
While I was researching, I thought of one more interesting thing in C#
List
do you think this can be useful ?
Muhammad Shahid FarooqPosted Aug 14, 2008, 6:59 PM
Answer 1) This is the best way.
Answer 2) For childern you create a column Children_Id and store the id (Forign Key) in that table
create another table for childrens that have three columns Children_Id, Gender & Name
According to above data When you read the children node entries made in two tables, One table contains children_Id and other table contains children information.