Upload half-million rows into SqlServer

Hi guys I need your advice

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.

Use BulkCopy.

• Bulk Copy Operations in SQL Server (ADO.NET)
• Sample code