public void GetAdminNewsReturnsCorrectCollection() { var mockNews = new Mock <LearningPlusNews>(); mockNews.Setup(n => n.ExpiresOn).Returns(DateTime.UtcNow.AddDays(2)); var mockSndNews = new Mock <LearningPlusNews>(); mockSndNews.Setup(n => n.ExpiresOn).Returns(DateTime.UtcNow.AddSeconds(5)); var mockOldNews = new Mock <LearningPlusNews>(); mockOldNews.Setup(n => n.ExpiresOn).Returns(DateTime.UtcNow.AddDays(-1)); var options = new DbContextOptionsBuilder <LearningPlusDbContext>() .UseInMemoryDatabase(databaseName: "GetAdminNews_News_Database") // Give a Unique name to the DB .Options; var dbContext = new LearningPlusDbContext(options); dbContext.News.Add(mockNews.Object); dbContext.News.Add(mockSndNews.Object); dbContext.News.Add(mockOldNews.Object); dbContext.SaveChanges(); var newsRepo = new DbRepository <LearningPlusNews>(dbContext); var lpNewsService = new LearningPlusNewsService(null, newsRepo); var news = lpNewsService.GetAdminNews(); news.Count.ShouldBe(2); }