public void SqlInsertOneTest()
{
var context = _dbContextFactory.Create <FakeEcDbContext>();
var fakeUserRepo = new FakeUserRepository(_dbContextFactory);
var sw = new Stopwatch();
sw.Start();
var user = CreateOneUser();
var count = fakeUserRepo.InsertByCommand(user);
sw.Stop();
Trace.WriteLine("Sql Insert " + count + ", 毫秒：" + sw.ElapsedMilliseconds);
context.Dispose();
}
public void SqlBatchInsertTest()
{
var total = 200;
var context = _dbContextFactory.Create <FakeEcDbContext>();
var fakeUserRepo = new FakeUserRepository(_dbContextFactory);
var sw = new Stopwatch();
sw.Start();
var users = CreateOneUser(total);
var time1 = sw.ElapsedMilliseconds;
sw.Restart();
var realTotal = users.Sum(item => fakeUserRepo.InsertByCommand(item));
sw.Stop();
context.Dispose();
Trace.WriteLine("Create FakeUser " + total + ", 毫秒：" + time1);
Trace.WriteLine("Sql Batch Insert " + total + ", 毫秒：" + sw.ElapsedMilliseconds);
}