public async Task NonAlcoholicCountAsyncShouldReturnCorrectCount() { var db = DbInfrastructure.GetDatabase(); const int NonAlcoholicDrinks = 150; var alcoholicCategory = new Category { Name = "Alcoholic" }; var nonAlcoholicCategory = new Category { Name = "Non-Alcoholic" }; await db.AddRangeAsync(alcoholicCategory, nonAlcoholicCategory); await db.SaveChangesAsync(); await this.SeedDataByCategory(db, 1234, alcoholicCategory.Id); await this.SeedDataByCategory(db, NonAlcoholicDrinks, nonAlcoholicCategory.Id); var drinkService = new DrinkService(db); var count = await drinkService.NonAlcoholicCountAsync(); count.Should().Be(NonAlcoholicDrinks); }