大数据批量插入数据库

public int BulkCopyTaskData( string dbTableName, DataTable dt)
{
int c = 0;
if (dt != null && dt.Rows.Count > 0)
{
using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(connectionString[0], SqlBulkCopyOptions.UseInternalTransaction))
{

sqlbulkcopy.DestinationTableName = dbTableName;//数据库中的表名
foreach (DataColumn dc in dt.Columns)
{
sqlbulkcopy.ColumnMappings.Add(dc.ColumnName, dc.ColumnName);

}

sqlbulkcopy.BatchSize = 10000;//每批次10000
sqlbulkcopy.WriteToServer(dt);//插入20000条记录时间:00:00:00.3276000 最快
c += dt.Rows.Count;
}
}
return c;
}