title: Upload half-million rows into SqlServer
body: <p>Hi guys I need your advice</p>
  
  <p>I need to upload about half-million rows from a xml file into a SqlServer table periodically. I could use SqlBulkCopy but there is some extra logic. I need to track changes in the xml files and copy that changes into another table.  What is the best way to do it?  I dont't want to use Entity Framework or LinqToSql because I want to set table names in the config file.</p>