public void ValidGetAllShouldDisplayAllHistoryUserRole() { var options = new DbContextOptionsBuilder <UsersDbContext>() .UseInMemoryDatabase(databaseName: nameof(ValidGetAllShouldDisplayAllHistoryUserRole)) .Options; using (var context = new UsersDbContext(options)) { var userService = new UserService(context, config); var added = new HistoryUserRole { User = new User { Username = "******", }, UserRole = new UserRole { Name = RoleConstants.REGULAR }, StartTime = DateTime.Now, EndTime = null }; var added2 = new HistoryUserRole { User = new User { Username = "******", }, UserRole = new UserRole { Name = RoleConstants.MODERATOR }, StartTime = DateTime.Now.AddDays(10), EndTime = null }; context.HistoryUserRoles.Add(added); context.HistoryUserRoles.Add(added2); context.SaveChanges(); // Act var result = userService.GetAllHistory(); // Assert Assert.AreEqual(2, result.Count()); Assert.AreNotEqual(0, result.Count()); } }