What's the best approach for reading in XML data and building a query to insert the values into a SQL Server DB?

Question

What's the best approach for reading in XML data and building a query to insert the values into a SQL Server DB?

Anyone have a best approach for this type of scenario?

Answer 1

Personally, I use a DataSet.ReadXML(). Then it places all the data into DataTables in the DataSet and then is much easier to loop through and manipulate the data.

Answer 2

SQL 2005 has very good xml capabilities. This is one technique using XML Parameters