public async Task ProjectsAreRetrievedTest() { using (var db = new ProjectContext(Utilities.TestDbContextOptions())) { // Arrange: seed database with Technicians var expectedProjects = SeedProjectTechnician.GetSeedingProjects(); await db.AddRangeAsync(expectedProjects); await db.SaveChangesAsync(); // Act: retrieve seeded Projects from database var result = await db.GetProjectsAsync(); // Assert: seeded and retrieved Projects match var actualProjects = Assert.IsAssignableFrom <List <Project> >(result); Assert.Equal( expectedProjects.OrderBy(a => a.ProjectID).Select(a => a.Title), actualProjects.OrderBy(a => a.ProjectID).Select(a => a.Title)); } }