Export XML to SQL Database (Complicated XML)

Question

I have XML which very complicated in structure, as below. My objective is to get all the data from the XML, dump into database as relational structure. What is the best way to achieve it using c#.

<a> 
   <b>
        <c> 
            <d>
                <e>....
                <e>
                <e>
            </d>
            <d>
            </d>
        </c>
     </b>

   <b>
        <c> 
            <d>
                <e>....
                <e>
                <e>
            </d>
            <d>
            </d>
        </c>
     </b>
</a>

This is way too broad a question. What have you tried? I suggest you start by looking at sites like this — Raj Ranjhan
– Raj Ranjhan, Commented Mar 24, 2012 at 2:57
I'm just starting the work, i just want to know the best approach. — dotnet_Profiler
– dotnet_Profiler, Commented Mar 24, 2012 at 3:45

Chuck Savage · Accepted Answer · 2012-03-24 16:14:04Z

1

As an exercise create classes for each node type.

Aka

class A
{
public B[] Bs; <- one-to-many
}

class B
{
public C C; <- one-to-one
}

class C
{
public D[] Ds; <- one-to-many
}

etc. With that you can start to see the relationships between classes and what goes into each class. Each class is potentially a table in the relational database. Since class A is really the root node, it probably isn't a table, but there for completeness.

answered Mar 24, 2012 at 16:14

Chuck Savage

12k6 gold badges53 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Export XML to SQL Database (Complicated XML)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related