read diff .xml file - 07-09-2010 , 12:00 AM
I want to know the best way of reading different types of .xml files with
different node structure and stored data in sql.
I know of few ways using XmlDocument, XmlTextReader, etc... but I need to
find out the best way.
I have not used reading Xml to Dataset or Linq to Xml, how good r they ?
My requirement is to read heaps of xml files with different node structures
and store data in sql.
Thanks to all,
Re: read diff .xml file - 07-09-2010 , 05:57 AM
Puja Parekh wrote:
SQL server in a column of type "xml"?
Or do you want to extract some data from an XML document and store the
data in SQL server in columns of a type other than "xml"?
And which version of .NET and which version of SQL server are you
And to judge what is best we need to define criteria to judge things.
For instance XmlDocument or XDocument are easier to use than a pure
XmlReader solution but will definitly consume more memory.
Martin Honnen --- MVP Data Platform Development
Re: read diff .xml file - 07-11-2010 , 07:01 PM
Thanks for the reply, sorry, for missing out some information.
I want to extract data from xml file and store data in SQL server in columns
of a type in sql server.
I am using .Net 3.5 and sql server 2005.
One of my friend suggested Linq to Xml. How good is that ?
"Martin Honnen" <mahotrash (AT) yahoo (DOT) de> wrote
|Thread Tools||Search this Thread|