The
ZZZ Projects Bulk Operations Library is the solution for you.
It allows you to effectuate various operations such as: Delete, Insert, Update and Merge on a substantial amount of data.
var operation = new SqlBulkOperation();
operation.BulkDelete(dt);
operation.BulkInsert(dt);
operation.BulkUpdate(dt);
operation.BulkMerge(dt);
It also offers more advanced features like output value, column formula, auditing, intercepting, logging and more.
Find out more on
http://zzzprojects.com/bulk-operations/ about the most advanced and flexible Bulk Operations library.