public void TestInitialize() { _repository = new Repository(); _repository.ExecuteCommand(cmd => { cmd.UseSql("delete from dbo.Records where Id > 676;"); }); }
public void TransactionTest() { var user1 = CreateNewUser(); user1 = _repository.SaveUser(user1); var id = user1.Id; _repository.BeginTransaction(tran => { _repository.ExecuteCommand(cmd => { cmd.UseSql($"delete from Users where Id = {id}"); }); //tran.Rollback(); }); user1 = _repository.GetUserById(user1.Id); Assert.IsNotNull(user1); Assert.AreEqual(user1.Id, id); var user2 = CreateNewUser(); user2 = _repository.SaveUser(user2); var id2 = user2.Id; _repository.BeginTransaction(tran => { _repository.ExecuteCommand(cmd => { cmd.UseSql($"delete from Users where Id = {id}"); }); _repository.DeleteUser(id2); tran.Rollback(); }); user1 = _repository.GetUserById(user1.Id); Assert.IsNotNull(user1); Assert.AreEqual(user1.Id, id); user2 = _repository.GetUserById(user2.Id); Assert.IsNotNull(user2); Assert.AreEqual(user2.Id, id2); _repository.DeleteTwoUsers(user1.Id, user2.Id); user1 = _repository.GetUserById(user1.Id); Assert.IsNull(user1); user2 = _repository.GetUserById(user2.Id); Assert.IsNull(user2); }