首页 > 技术文章 > Linq分批次,每组1000条

xiaohouye 2019-08-20 11:12 原文

/// <summary>
/// 分组插入每次插入1000
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
private List<List<IEnumerable<string>>> GroupResult((IList<string> Columns, IList<IEnumerable<string>> Rows) data)
{
var rows = data.Rows;
var q = from e in rows.Select((item, index) => new { index, item })
group e by e.index / 1000
into g
select g.Select(e => e.item).ToList();
return q.ToList();
}

推荐阅读