Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
XML Bulk + .Net

Answered XML Bulk + .Net

  • Monday, April 30, 2012 9:34 AM
     
     
    Sign In to Vote
    0

    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


     

All Replies