Asp.net uses SqlBulkCopy to insert data to SQLServer quickly

This morning, the reader received a cnblogs subscription and saw an article about SQL statement quick insert. Speaking of SqlBulkCopy, it feels good. According to his test, SqlBulkCopy is nearly 30 times faster than normal insert,

This morning, the reader received a cnblogs subscription and saw an article about SQL statement quick insert. Speaking of SqlBulkCopy, it feels good. According to his test, SqlBulkCopy is nearly 30 times faster than normal insert,

In this case, the time for issuing the ticket will be 10 minutes-> 20 seconds. This is amazing.
Now, let's go to the demo, test, and change it to a method test that we generally use. NND is really fast.
Paste my Demo here:
The Code is as follows:
Using System;
Using System. Diagnostics;
Using System. Data;
Using System. Data. SqlClient;
Using Microsoft. ApplicationBlocks. Data;
Namespace ConsoleAppInsertTest
{
Class Program
{
Static int count = 1000000; // Number of inserted items
Static void Main (string [] args)
{
Long sqlBulkCopyInsertRunTime = SqlBulkCopyInsert ();
Console. WriteLine (string. Format ("the time used to insert {1} pieces of data using SqlBulkCopy is {0} millisecond", sqlBulkCopyInsertRunTime, count ));
Long commonInsertRunTime = CommonInsert ();
Console. WriteLine (string. Format ("the time taken to insert {1} pieces of data in normal mode is {0} millisecond", commonInsertRunTime, count ));
Console. ReadKey ();
}
///
/// Insert data normally
///
///
Private static long CommonInsert ()
{
Stopwatch stopwatch = new Stopwatch ();
Stopwatch. Start ();
For (int I = 0; I <count; I ++)
{
SqlHelper. ExecuteNonQuery (SqlHelper. SqlConnection, CommandType. Text, "insert into passport (PassportKey) values ('" + Guid. NewGuid () + "')");
}
Stopwatch. Stop ();
Return stopwatch. ElapsedMilliseconds;
}
///
/// Use SqlBulkCopy to insert data
///
///
Private static long SqlBulkCopyInsert ()
{
Stopwatch stopwatch = new Stopwatch ();
Stopwatch. Start ();
DataTable dataTable = GetTableSchema ();
For (int I = 0; I <count; I ++)
{
DataRow dataRow = dataTable. NewRow ();
DataRow [2] = Guid. NewGuid ();
DataTable. Rows. Add (dataRow );
}
// Console. WriteLine (stopwatch. ElapsedMilliseconds); // The data initialization time.
SqlBulkCopy sqlBulkCopy = new SqlBulkCopy (SqlHelper. SqlConnection );
SqlBulkCopy. DestinationTableName = "Passport ";
If (dataTable! = Null & dataTable. Rows. Count! = 0)
{
SqlBulkCopy. WriteToServer (dataTable );
}
SqlBulkCopy. Close ();
Stopwatch. Stop ();
Return stopwatch. ElapsedMilliseconds;
}
Private static DataTable GetTableSchema ()
{
Return SqlHelper. ExecuteDataset (SqlHelper. SqlConnection, CommandType. Text, "select * from Passport where 1 = 2"). Tables [0];
}
}
}