Moq & EF6 - 模拟 EF6 删除方法不删除对象

Question

我正在尝试模拟我的EF6DbContext，它都适用于Add，Update，Find方法。 但由于未知原因，它不适用于Remove方法。

理论上，删除后，Students集合应该只剩下 1 个返回。 但它不断返回计数 - 2。

我进行了 3 次 Moq.Verify检查，以确保调用所有方法并确实执行它们。 但它实际上并没有从学生收藏中删除该项目。

如果我评论Assert.Equal检查计数的行，则整个测试都通过了。

删除 XUnit 方法

[Fact]
public void Delete()
{            
Mock<DbContexts.MVCWebAppDbContext> dbContext = new Mock<DbContexts.MVCWebAppDbContext>();
IStudentsService studentService = new StudentsService(dbContext.Object);
var students = new List<Student>()
{
new Student() { StudentID = 1, RefNo = "12456343", FirstName = "John", LastName = "Smith", DateOfBirth = DateTime.Now.AddYears(-10), DateCreated = DateTime.Now },
new Student() { StudentID = 2, RefNo = "87984564", FirstName = "Pete", LastName = "Luck", DateOfBirth = DateTime.Now.AddYears(-20), DateCreated = DateTime.Now.AddDays(1) }
};
var mockSet = new Mock<DbSet<Student>>();
mockSet.As<IQueryable<Student>>().Setup(m => m.Provider).Returns(students.AsQueryable().Provider);
mockSet.As<IQueryable<Student>>().Setup(m => m.Expression).Returns(students.AsQueryable().Expression);
mockSet.As<IQueryable<Student>>().Setup(m => m.ElementType).Returns(students.AsQueryable().ElementType);
mockSet.As<IQueryable<Student>>().Setup(m => m.GetEnumerator()).Returns(students.AsQueryable().GetEnumerator());
mockSet.Setup(m => m.Remove(It.IsAny<Student>())).Callback<Student>((entity) => students.Remove(entity));
dbContext.Setup(c => c.Students).Returns(mockSet.Object);
int idToDelete = 1;
dbContext.Setup(s => s.Students.Find(idToDelete)).Returns(students.Single(s => s.StudentID == idToDelete));
// call delete method now
studentService.Delete(idToDelete);
// 1 object deleted, it should return 1
Assert.Equal(1, students.Count());  // <----- Error here
dbContext.Verify(s => s.Students.Find(idToDelete), Times.Once);
dbContext.Verify(s => s.Students.Remove(It.IsAny<Student>()), Times.Once);
dbContext.Verify(s => s.SaveChanges(), Times.Once);
}

学生服务.cs删除方法

MVCWebAppDbContext _context;
public StudentsService(MVCWebAppDbContext context)
{
_context = context;
}
public int Delete(int id)
{
var objToDelete = _context.Students.Find(id);
if (objToDelete != null)
{
_context.Students.Remove(objToDelete);
return _context.SaveChanges();
}
return -1;
}

你们能帮我解决这个问题吗 删除方法 嘲笑？

Answer 1

替换

mockSet
.Setup(m => m.Remove(It.IsAny<Student>()))
.Callback<Student>((entity) => students.Remove(entity));

跟

dbContext
.Setup(m => m.Students.Remove(It.IsAny<Student>()))
.Callback<Student>((entity) => students.Remove(entity));

大多数设置都是使用覆盖DbSet.Remove上的设置的DbContext.Students完成

的 实际上，您实际上可以删除所有DbSet模拟，并且测试仍然会通过

[Fact]
public void Delete() {
var dbContext = new Mock<DbContexts.MVCWebAppDbContext>();
IStudentsService studentService = new StudentsService(dbContext.Object);
var students = new List<Student>()
{
new Student() { StudentID = 1, RefNo = "12456343", FirstName = "John", LastName = "Smith", DateOfBirth = DateTime.Now.AddYears(-10), DateCreated = DateTime.Now },
new Student() { StudentID = 2, RefNo = "87984564", FirstName = "Pete", LastName = "Luck", DateOfBirth = DateTime.Now.AddYears(-20), DateCreated = DateTime.Now.AddDays(1) }
};
dbContext
.Setup(m => m.Students.Remove(It.IsAny<Student>()))
.Callback<Student>((entity) => students.Remove(entity));
int idToDelete = 1;
dbContext
.Setup(s => s.Students.Find(idToDelete))
.Returns(students.Single(s => s.StudentID == idToDelete));
// call delete method now
studentService.Delete(idToDelete);
// 1 object deleted, it should return 1
Assert.AreEqual(1, students.Count());
dbContext.Verify(s => s.Students.Find(idToDelete), Times.Once);
dbContext.Verify(s => s.Students.Remove(It.IsAny<Student>()), Times.Once);
dbContext.Verify(s => s.SaveChanges(), Times.Once);
}