Save XML directly to Database with C#
Posted
by LifeH2O
on Stack Overflow
See other posts from Stack Overflow
or by LifeH2O
Published on 2010-06-07T17:42:50Z
Indexed on
2010/06/07
18:12 UTC
Read the original article
Hit count: 313
Here is a part of my xml file
<teams>
<team-profile>
<name>Australia</name>
<id>1</id>
<stats type="Test">
<span>1877-2010</span>
<matches>721</matches>
<won>339</won>
<lost>186</lost>
<tied>2</tied>
<draw>194</draw>
<percentage>47.01</percentage>
</stats>
<squad>
<player id="135" fullname="Shane Warne"/>
<player id="136" fullname="Damien Martyn"/>
<player id="138" fullname="Michael Clarke"/>
</squad>
</team-profile>
</team>
I have read somewhere that there is a way to save this XML directly to database. I am using VS2010. I have created the dataset, for the data i need from this xml. Is there any way to map this XML directly on dataset? Any other idea? I also have to save some other more complex XML files to database.
I have tried xsd.exe to create xsd schema for this XML.
© Stack Overflow or respective owner