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); }