try to use SqlBulkCopy Method in ADO.Net.
Code:
DataTable sourceDataTable = new DataTable();
string DestinationConnString = "";
string DestinationTableName = "";
SqlBulkCopy bulkDataCopy = new SqlBulkCopy(DestinationConnString, SqlBulkCopyOptions.TableLock)
{
DestinationTableName = DestinationTableName,
BatchSize = 100000,
BulkCopyTimeout = 360
};
bulkDataCopy.WriteToServer(sourceDataTable);