public void BulkInsert()
{
//7.9秒
Stopwatch watch = new Stopwatch();
watch.Start();
var dt = new DataTable();
dt.Columns.Add("AutoID", typeof(int));
dt.Columns.Add("UserName", typeof(string));
for (var i = 0; i < 1000000; i++)
{
var dr = dt.NewRow();
dr["AutoID"] = 0;
dr["UserName"] = "******" + i.ToString();
dt.Rows.Add(dr);
}
sqlserver.BulkInsert <DbMaintenanceTestInfo>(dt);
watch.Stop();
Console.WriteLine("共运行时长：" + watch.ElapsedMilliseconds + "毫秒");
}
