Question

Entity Framework 批量插入很慢吗

Answer 1

以下为我的测试结果：插入十万条结果
using (var ctx = new CSLDBEntities())
{
for (int i = 0; i < 100000; i++)
{
ResourceLock resourceLock = new ResourceLock();
resourceLock.session_id = Guid.NewGuid().ToString();

ctx.ResourceLock.ApplyChanges(resourceLock);
}
ctx.SaveChanges();
}

var Target = DateTime.Now;

var res = Target - orign;
时间为：22秒