批量插入数据

1、SqlBulkCopy插入数据

/// <summary>
        /// 使用SqlBulkCopy方式插入数据
        /// </summary>
        /// <param name="dataTable"></param>
        /// <param name="tableName">目标表名称</param>
        /// <param name="connectionString">数据库连接字符串</param>
        /// <returns></returns>
        private static long SqlBulkCopyInsert(DataTable dataTable, string tableName, string connectionString)
        {
            Stopwatch stopwatch = new Stopwatch();//用于当前实例完成时的所用时间
            stopwatch.Start();

            SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(connectionString);
            sqlBulkCopy.DestinationTableName = tableName;
            sqlBulkCopy.BatchSize = dataTable.Rows.Count;
            SqlConnection sqlConnection = new SqlConnection(connectionString);
            sqlConnection.Open();
            if (dataTable.Rows.Count > 0)
            {
                sqlBulkCopy.WriteToServer(dataTable);
            }
            sqlBulkCopy.Close();
            sqlConnection.Close();

            stopwatch.Stop();
            return stopwatch.ElapsedMilliseconds;
        }