asp.net use sqlbulkcopy to insert data into SQL Server

In this way, our Fashui ticket time will be 10 minutes-->20 seconds, which is amazing.
As a then, the next demo, testing, change to their own general methods of testing, NND, can really say is the speed.
Put my Demo:SqlBulkCopy.rar in here.
Copy CodeThe 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 bars inserted
static void Main (string[] args)
{
Long sqlbulkcopyinsertruntime = Sqlbulkcopyinsert ();
Console.WriteLine (String. Format ("The time used to insert {1} data using SqlBulkCopy is {0} milliseconds", Sqlbulkcopyinsertruntime, Count));
Long commoninsertruntime = Commoninsert ();
Console.WriteLine (String. Format (the time spent in the normal way to insert {1} data is {0} milliseconds, Commoninsertruntime, count));
Console.readkey ();
}
<summary>
Use normal Insert Data
</summary>
<returns></returns>
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;
}
<summary>
Inserting data using the SqlBulkCopy method
</summary>
<returns></returns>
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);//Initializing Data 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];
}
}
}

From cnblogs article SQL BULK INSERT data performance Detailed comparison of several scenarios