public async Task GetGenresCountShouldReturnCorrectCountIfThereAreDeleted() { var options = new DbContextOptionsBuilder <AlexandriaDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .Options; var db = new AlexandriaDbContext(options); await db.Genres.AddRangeAsync( new Genre { Name = "test1", Description = "description1", }, new Genre { Name = "test2", Description = "description2", }, new Genre { Name = "test3", Description = "description3", IsDeleted = true, }); await db.SaveChangesAsync(); var genresService = new GenresService(db); var result = await genresService.GetGenresCountAsync(); Assert.Equal(2, result); }