public async Task ReturnAllNotDeletedBars() { var barFactoryMock = new Mock <IBarFactory>(); var barCocktailFactoryMock = new Mock <IBarCocktailFactory>(); var imagaUrlTest = "https://www.google.com/"; var barTestName1 = "NameTest1"; var barTestName2 = "NameTest2"; var cityTest = new City { Name = "SofiaTest" }; var options = TestUtilities.GetOptions(nameof(ReturnAllNotDeletedBars)); using (var arrangeContext = new CocktailMagicianDb(options)) { arrangeContext.Cities.Add(cityTest); await arrangeContext.SaveChangesAsync(); } using (var actContext = new CocktailMagicianDb(options)) { var cityId = await actContext.Cities.Where(c => c.Name == cityTest.Name).Select(c => c.Id).FirstAsync(); var address1DTOTest = new AddressDTO { Name = "AddressTest1", CityId = cityId, Latitude = 1.1, Longitude = 1.1 }; var addressTest1 = new Address { Name = "AddressTest1", CityId = cityId, Latitude = 1.1, Longitude = 1.1 }; var address2DTOTest = new AddressDTO { Name = "AddressTest2", CityId = cityId, Latitude = 1.1, Longitude = 1.1 }; var addressTest2 = new Address { Name = "AddressTest2", CityId = cityId, Latitude = 1.1, Longitude = 1.1 }; var bar1 = new Bar { Name = barTestName1, ImagePath = imagaUrlTest, Address = addressTest1, }; var bar2 = new Bar { Name = barTestName2, ImagePath = imagaUrlTest, Address = addressTest1, IsDeleted = true }; actContext.Bars.Add(bar1); actContext.Bars.Add(bar2); await actContext.SaveChangesAsync(); } using (var assertContext = new CocktailMagicianDb(options)) { var sut = new BarServices(assertContext, barFactoryMock.Object, barCocktailFactoryMock.Object); var listTest = await sut.GetAllDTOAsync(5, 1); Assert.IsTrue(listTest.Count() == 1); Assert.IsTrue(assertContext.Bars.Count() == 2); } }