C# 超大数据量导入 SqlBulkCopy

        public static void ImportTempTableDataIndex(DataSet ds,string TempTableName,string strSqlConnection)
        {

            //dcrenl:获取写入连接
            string str = strSqlConnection;
            SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder(str);
            string DataSource = sb.DataSource;
            string PersistSecurityInfo = sb.PersistSecurityInfo.ToString();
            string Pwd = sb.Password;
            string UserID = sb.UserID;
            string basestr = sb.InitialCatalog;
            string InitialCatalog = sb.InitialCatalog;

            //dcrenl:开始写入数据
            str = $"Data Source={DataSource};database={basestr};user={UserID};password={Pwd}";
            using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(str, SqlBulkCopyOptions.UseInternalTransaction))
            {
                //DataSet与数据库表一一对应时不需要写对应关系
                //sqlBulkCopy.ColumnMappings.Add("ID", "ID");


                sqlBulkCopy.EnableStreaming = true;
                sqlBulkCopy.DestinationTableName = $"{TempTableName}";
                sqlBulkCopy.WriteToServer(ds.Tables[0]);

                sqlBulkCopy.Close();
            }
            ds.Dispose();
        }

 

此方法测试30万记录，20个varchar(255)字段，导入6秒左右完成。