SqlBulkCopy批量插入大数据

        /// <summary>
        /// 按照SqlBulkCopy写入数据库
        /// </summary>
        /// <param name="dt">数据表</param>
        /// <param name="tableName">数据库表名</param>
        public static void WriteDataBySqlBulkCopy(DataTable dt, string tableName, string connStr = null)
        {
            //判空
            if (dt == null || dt.Rows.Count == 0 || string.IsNullOrEmpty(tableName))
            {
                return;
            }
            SqlConnection con = new SqlConnection(connStr);
            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }
            //此部分是重要的东西
            using (System.Data.SqlClient.SqlBulkCopy sbc = new System.Data.SqlClient.SqlBulkCopy(con))
            {

                try
                {
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {

                        sbc.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName); //设置目标表和源数据的列映射
                    }
                    sbc.DestinationTableName = tableName;  //取得目标表名
                    sbc.WriteToServer(dt);

                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
                finally
                {
                    if (con.State == ConnectionState.Open)
                    {
                        con.Close();
                    }
                }
            }
        }