/// <summary>
/// 批次Add，批次SaveChange
/// </summary>
/// <param name="ItemData"></param>
private static void TestRun03(IEnumerable <Users> ItemData)
{
TSQL2019Entities dbContext = new TSQL2019Entities();
var batchCount = 100;
var i = 0;
foreach (var item in ItemData)
{
dbContext.Users.Add(item);
if (i % batchCount == 0)
{
dbContext.SaveChanges();
}
}
dbContext.SaveChanges();
}
/// <summary>
/// 逐筆Add，一次SaveChange
/// </summary>
/// <param name="ItemData"></param>
private static void TestRun02(IEnumerable <Users> ItemData)
{
TSQL2019Entities dbContext = new TSQL2019Entities();
foreach (var item in ItemData)
{
dbContext.Users.Add(item);
}
dbContext.SaveChanges();
}
/// <summary>
/// 批次Add，批次SaveChange，最後關閉DBContext
/// </summary>
/// <param name="ItemData"></param>
private static void TestRun04(IEnumerable <Users> ItemData)
{
var batchCount = 100;
var skipCount = 0;
var _ItemData = ItemData.ToArray();
for (int i = 1; i <= (ItemData.Count() / batchCount); i++)
{
using (TSQL2019Entities dbContext = new TSQL2019Entities())
{
for (int j = 0; j < batchCount; j++)
{
dbContext.Users.Add(_ItemData[j]);
}
dbContext.SaveChanges();
}
}
}