方法1：DataTable方式

        /// <summary>
        /// 批量新增數(shù)據(jù)（限Excel使用）
        /// </summary>
        /// <param name="dt">DataTable（其中的列名要與數(shù)據(jù)庫(kù)表列名一致）</param>
        public int BatchAdd(DataTable dt)
        {
            int rs = 1;
            SqlConnection sqlConn =
                new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            try
            {
                sqlConn.Open();
                SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(sqlConn);
                sqlbulkcopy.DestinationTableName = "PhoneToQRCode";//數(shù)據(jù)庫(kù)中的表名
                sqlbulkcopy.WriteToServer(dt);
            }
            catch (Exception ex)
            {
                rs = 0;
            }
            finally
            {
                sqlConn.Close();
            }
            return rs;
        }

方法2：使用List方式

        /// <summary>
        /// 批量插入
        /// </summary>
        /// <param name="conn"></param>
        /// <param name="list">源數(shù)據(jù)</param>
        internal static void BulkCopy<T>(IDbConnection conn, IEnumerable<T> list)
        {
            var dt = list.ToDataTable();

            using (conn)
            {
                if (conn.State == ConnectionState.Closed)
                    conn.Open();

                using (var sqlbulkcopy = new SqlBulkCopy((SqlConnection)conn))
                {
                    sqlbulkcopy.DestinationTableName = dt.TableName;
                    for (var i = 0; i < dt.Columns.Count; i++)
                    {
                        sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
                    }
                    sqlbulkcopy.WriteToServer(dt);
                }
            }
        }

        /// <summary>
        /// List轉(zhuǎn)DataTable
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="list">集合</param>
        /// <returns></returns>
        public static DataTable ToDataTable<T>(this IEnumerable<T> list)
        {
            var type = typeof(T);

            var properties = type.GetProperties().ToList();

            var newDt = new DataTable(type.Name);

            properties.ForEach(propertie =>
            {
                Type columnType;
                if (propertie.PropertyType.IsGenericType && propertie.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>))
                {
                    columnType = propertie.PropertyType.GetGenericArguments()[0];
                }
                else
                {
                    columnType = propertie.PropertyType;
                }

                newDt.Columns.Add(propertie.Name, columnType);
            });

            foreach (var item in list)
            {
                var newRow = newDt.NewRow();

                properties.ForEach(propertie =>
                {
                    newRow[propertie.Name] = propertie.GetValue(item, null) ?? DBNull.Value;
                });

                newDt.Rows.Add(newRow);
            }

            return newDt;
        }