public void Delete_ReturnsFalse_WhenZeroDatabaseRowsAffected() { Mock<IDbDataParameter> mockParameter = new Mock<IDbDataParameter>(); Mock<IDataParameterCollection> mockParameterCollection = new Mock<IDataParameterCollection>(); Mock<IDbCommand> mockCommand = new Mock<IDbCommand>(); mockCommand.Setup(cmd => cmd.ExecuteNonQuery()).Returns(0); mockCommand.Setup(cmd => cmd.CreateParameter()).Returns(mockParameter.Object); mockCommand.Setup(cmd => cmd.Parameters).Returns(mockParameterCollection.Object); Mock<IDbConnection> mockConnection = new Mock<IDbConnection>(); mockConnection.Setup(conn => conn.CreateCommand()).Returns(mockCommand.Object); HobbitDataManager dataManager = new HobbitDataManager(mockConnection.Object); bool deleted = dataManager.Delete(ID); Assert.False(deleted); mockCommand.Verify(cmd => cmd.ExecuteNonQuery(), Times.Once); }
public void Delete_ReturnsFalse_ForUnknownHobbit() { HobbitDataManager dataManager = new HobbitDataManager(); Random prng = new Random(); bool idExists = true; long someId = 0; while (idExists) { someId = Convert.ToInt64(prng.Next()); Hobbit someHobbit; idExists = dataManager.TryGet(someId, out someHobbit); } bool deleted = dataManager.Delete(someId); Assert.False(deleted); }
public void Delete_ReturnsTrue_ForKnownHobbit() { Hobbit testHobbit = new Hobbit("Deletable Hobbit", FAMILY_NAME, BIRTH_YEAR, DEATH_YEAR, ID); HobbitDataManager dataManager = new HobbitDataManager(); Hobbit insertedHobbit = dataManager.Insert(testHobbit); bool deleted = dataManager.Delete(insertedHobbit.Id); Hobbit hobbit; bool foundHobbit = dataManager.TryGet(insertedHobbit.Id, out hobbit); Assert.True(deleted); Assert.False(foundHobbit); }