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));
            }
        }