title: Best way to insert large amounts of data from a WCF call into SQL
body: <p>I'm calling a third party web service that returns a large amount of XML (1000s of rows).  What is the best way to get the XML into an underlying SQL server 2008 R2 table.  At the moment I am retrieving the XML and deserializing into .NET class collections using the associated XSD.  I then iterate through the collection making multiple calls to a INSERT stored proc.  The performance isn't too bad but I'm sure there must be a quicker way to do this.  Should I be looking at SqlBulkCopy?  I've heard that LINQ-TO-SQL is slow when it comes to bulk inserts/updates.  Any advice would be welcome.  </p>