public void GetAllWebSites_ReturnsWebSites() { // Arrange using (var context = new ApplicationDbContext(_options)) { context.Database.EnsureDeleted(); AddResourceTypes(context); AddCategories(context); context.Resources.AddRange( new Resource("test", "test", context.ResourceTypes.First(a => a.Id == 1), context.ResourceCategories.First(a => a.Id == 1)), new Resource("test2", "test2", context.ResourceTypes.First(a => a.Id == 1), context.ResourceCategories.First(a => a.Id == 1)), new Resource("test3", "test3", context.ResourceTypes.First(a => a.Id == 2), context.ResourceCategories.First(a => a.Id == 1)), new Resource("test3", "test3", context.ResourceTypes.First(a => a.Id == 1), context.ResourceCategories.First(a => a.Id == 2)) ); context.SaveChanges(); IResourceDataAccess webSiteDataAccess = new ResourceDataAccess(context); // Act var webSites = webSiteDataAccess.GetAllWebSites(); // Assert Assert.Equal(3, webSites.Count()); Assert.Equal("test", webSites.First().Name); } }