public void GetAllActive_WithInvalidClinics_ShouldReturnEmptyClinicsCollection() { var options = new DbContextOptionsBuilder <DentHubContext>() .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()) // Give a Unique name to the DB .Options; var dbContext = new DentHubContext(options); var clinic = new Clinic { Id = 10, IsActive = true, Name = "Clinic 1", }; var dentist = new DentHubUser { Id = "1", IsActive = false, ClinicId = 1 }; var clinic2 = new Clinic { Id = 2, IsActive = false, Name = "Clinic 2", }; var dentist2 = new DentHubUser { Id = "2", IsActive = true, ClinicId = 2 }; dbContext.Clinics.Add(clinic); dbContext.Clinics.Add(clinic2); dbContext.DentHubUsers.Add(dentist); dbContext.DentHubUsers.Add(dentist2); dbContext.SaveChanges(); var repository = new DbRepository <Clinic>(dbContext); var service = new ClinicService(repository); var result = service.GetAllActive(); Assert.Empty(result); }