XML Bulk + .Net

Question

Hi All,

We've got a C# ASP.Net web application that takes CSV files, validates it and then processes it (insert/update into many database tables). We've found the performance to be very slow so are thinking of using SQL XML Bulk Load 4.0. Firstly, if anyone has had similar issues or has used SQL XML Bulk would you also suggest to use SQL XML Bulk loaded to get round this issue?

Secondly, looking at the examples it seems it can take a XML and by setting up an XSD it can update/insert records into database tables. However can this also be done using the .Net Managed Classes? Or do I have to use Invoke? 

Thanks for any insight and help - it would be much appreciated.

Kind regards

Sidharth

Answer 1

This is how to do it with VBScript.  The libraries are the same:

How to import XML into SQL Server with the XML Bulk Load component 
http://support.microsoft.com/kb/316005

Answer 2

Thanks