C# Eval - linq-dynamic-all-examples - Example 4 | C# Online Compiler

C# Eval - linq-dynamic-all-examples - Example 4 by ZZZ Projects

using System;
using System.Linq;
using System.Collections.Generic;

					
public class Program
{
	public static void Main()
	{
		var products = getList();
	
		var productGroups = products.GroupBy(p => p.Category)
			.Where(g => g.All(p => p.UnitsInStock > 0))
			.Select(g => new {Category = g.Key, Products = g});
			
		Console.WriteLine("Count before All : " + products.Count());
		
		int newCount = 0;
		
		foreach (var group in productGroups) 
		{
			newCount+= group.Products.Count();
		}
		
		Console.WriteLine("Count After All : " + newCount);
		
		foreach (var group in productGroups) 
		{
			Console.WriteLine(group.Category );
			
			foreach(var product in  group.Products) 
			{
				Console.WriteLine("ProductID = " + "ProductName : " + product.ProductName+ " Category : "  + product.Category+" UnitPrice : "  + product.UnitPrice+ " UnitPrice : "  + product.UnitPrice+" UnitsInStock : " + product.UnitsInStock);
			}
		}
	}
	
	public static List<Product> getList()
	{
		return  new List<Product>        {  new Product {ProductID = 1, ProductName = "Chai", Category = "Beverages", UnitPrice = 18.0000M, UnitsInStock = 39},
						new Product {ProductID = 2, ProductName = "Chang", Category = "Beverages", UnitPrice = 19.0000M, UnitsInStock = 17},
						new Product {ProductID = 3, ProductName = "Aniseed Syrup", Category = "Condiments", UnitPrice = 10.0000M, UnitsInStock = 13},
						new Product {ProductID = 4, ProductName = "Chef Anton's Cajun Seasoning", Category = "Condiments", UnitPrice = 22.0000M, UnitsInStock = 53},
						new Product {ProductID = 5, ProductName = "Chef Anton's Gumbo Mix", Category = "Condiments", UnitPrice = 21.3500M, UnitsInStock = 0},
						new Product {ProductID = 6, ProductName = "Grandma's Boysenberry Spread", Category = "Condiments", UnitPrice = 25.0000M, UnitsInStock = 120},
						new Product {ProductID = 7, ProductName = "Uncle Bob's Organic Dried Pears", Category = "Produce", UnitPrice = 30.0000M, UnitsInStock = 15},
						new Product {ProductID = 8, ProductName = "Northwoods Cranberry Sauce", Category = "Condiments", UnitPrice = 40.0000M, UnitsInStock = 6},
						new Product {ProductID = 9, ProductName = "Mishi Kobe Niku", Category = "Meat/Poultry", UnitPrice = 97.0000M, UnitsInStock = 29},
						new Product {ProductID = 10, ProductName = "Ikura", Category = "Seafood", UnitPrice = 31.0000M, UnitsInStock = 31},
						new Product {ProductID = 11, ProductName = "Queso Cabrales", Category = "Dairy Products", UnitPrice = 21.0000M, UnitsInStock = 22},
						new Product {ProductID = 12, ProductName = "Queso Manchego La Pastora", Category = "Dairy Products", UnitPrice = 38.0000M, UnitsInStock = 86},
						new Product {ProductID = 13, ProductName = "Konbu", Category = "Seafood", UnitPrice = 6.0000M, UnitsInStock = 24},
						new Product {ProductID = 14, ProductName = "Tofu", Category = "Produce", UnitPrice = 23.2500M, UnitsInStock = 35},
						new Product {ProductID = 15, ProductName = "Genen Shouyu", Category = "Condiments", UnitPrice = 15.5000M, UnitsInStock = 39},
						new Product {ProductID = 16, ProductName = "Pavlova", Category = "Confections", UnitPrice = 17.4500M, UnitsInStock = 29},
						new Product {ProductID = 17, ProductName = "Alice Mutton", Category = "Meat/Poultry", UnitPrice = 39.0000M, UnitsInStock = 0},
						new Product {ProductID = 18, ProductName = "Carnarvon Tigers", Category = "Seafood", UnitPrice = 62.5000M, UnitsInStock = 42},
						new Product {ProductID = 19, ProductName = "Teatime Chocolate Biscuits", Category = "Confections", UnitPrice = 9.2000M, UnitsInStock = 25},
						new Product {ProductID = 20, ProductName = "Sir Rodney's Marmalade", Category = "Confections", UnitPrice = 81.0000M, UnitsInStock = 40},
						new Product {ProductID = 21, ProductName = "Sir Rodney's Scones", Category = "Confections", UnitPrice = 10.0000M, UnitsInStock = 3},
						new Product {ProductID = 22, ProductName = "Gustaf's Knäckebröd", Category = "Grains/Cereals", UnitPrice = 21.0000M, UnitsInStock = 104},
						new Product {ProductID = 23, ProductName = "Tunnbröd", Category = "Grains/Cereals", UnitPrice = 9.0000M, UnitsInStock = 61},
						new Product {ProductID = 24, ProductName = "Guaraná Fantástica", Category = "Beverages", UnitPrice = 4.5000M, UnitsInStock = 20},
						new Product {ProductID = 25, ProductName = "NuNuCa Nuß-Nougat-Creme", Category = "Confections", UnitPrice = 14.0000M, UnitsInStock = 76},
						new Product {ProductID = 26, ProductName = "Gumbär Gummibärchen", Category = "Confections", UnitPrice = 31.2300M, UnitsInStock = 15},
						new Product {ProductID = 27, ProductName = "Schoggi Schokolade", Category = "Confections", UnitPrice = 43.9000M, UnitsInStock = 49},
						new Product {ProductID = 28, ProductName = "Rössle Sauerkraut", Category = "Produce", UnitPrice = 45.6000M, UnitsInStock = 26},
						new Product {ProductID = 29, ProductName = "Thüringer Rostbratwurst", Category = "Meat/Poultry", UnitPrice = 123.7900M, UnitsInStock = 0},
						new Product {ProductID = 30, ProductName = "Nord-Ost Matjeshering", Category = "Seafood", UnitPrice = 25.8900M, UnitsInStock = 10},
						new Product {ProductID = 31, ProductName = "Gorgonzola Telino", Category = "Dairy Products", UnitPrice = 12.5000M, UnitsInStock = 0},
						new Product {ProductID = 32, ProductName = "Mascarpone Fabioli", Category = "Dairy Products", UnitPrice = 32.0000M, UnitsInStock = 9},
						new Product {ProductID = 33, ProductName = "Geitost", Category = "Dairy Products", UnitPrice = 2.5000M, UnitsInStock = 112},
						new Product {ProductID = 34, ProductName = "Sasquatch Ale", Category = "Beverages", UnitPrice = 14.0000M, UnitsInStock = 111},
						new Product {ProductID = 35, ProductName = "Steeleye Stout", Category = "Beverages", UnitPrice = 18.0000M, UnitsInStock = 20},
						new Product {ProductID = 36, ProductName = "Inlagd Sill", Category = "Seafood", UnitPrice = 19.0000M, UnitsInStock = 112},
						new Product {ProductID = 37, ProductName = "Gravad lax", Category = "Seafood", UnitPrice = 26.0000M, UnitsInStock = 11},
						new Product {ProductID = 38, ProductName = "Côte de Blaye", Category = "Beverages", UnitPrice = 263.5000M, UnitsInStock = 17},
						new Product {ProductID = 39, ProductName = "Chartreuse verte", Category = "Beverages", UnitPrice = 18.0000M, UnitsInStock = 69},
						new Product {ProductID = 40, ProductName = "Boston Crab Meat", Category = "Seafood", UnitPrice = 18.4000M, UnitsInStock = 123},
						new Product {ProductID = 41, ProductName = "Jack's New England Clam Chowder", Category = "Seafood", UnitPrice = 9.6500M, UnitsInStock = 85},
						new Product {ProductID = 42, ProductName = "Singaporean Hokkien Fried Mee", Category = "Grains/Cereals", UnitPrice = 14.0000M, UnitsInStock = 26},
						new Product {ProductID = 43, ProductName = "Ipoh Coffee", Category = "Beverages", UnitPrice = 46.0000M, UnitsInStock = 17},
						new Product {ProductID = 44, ProductName = "Gula Malacca", Category = "Condiments", UnitPrice = 19.4500M, UnitsInStock = 27},
						new Product {ProductID = 45, ProductName = "Rogede sild", Category = "Seafood", UnitPrice = 9.5000M, UnitsInStock = 5},
						new Product {ProductID = 46, ProductName = "Spegesild", Category = "Seafood", UnitPrice = 12.0000M, UnitsInStock = 95},
						new Product {ProductID = 47, ProductName = "Zaanse koeken", Category = "Confections", UnitPrice = 9.5000M, UnitsInStock = 36},
						new Product {ProductID = 48, ProductName = "Chocolade", Category = "Confections", UnitPrice = 12.7500M, UnitsInStock = 15},
						new Product {ProductID = 49, ProductName = "Maxilaku", Category = "Confections", UnitPrice = 20.0000M, UnitsInStock = 10},
						new Product {ProductID = 50, ProductName = "Valkoinen suklaa", Category = "Confections", UnitPrice = 16.2500M, UnitsInStock = 65},
						new Product {ProductID = 51, ProductName = "Manjimup Dried Apples", Category = "Produce", UnitPrice = 53.0000M, UnitsInStock = 20},
						new Product {ProductID = 52, ProductName = "Filo Mix", Category = "Grains/Cereals", UnitPrice = 7.0000M, UnitsInStock = 38},
						new Product {ProductID = 53, ProductName = "Perth Pasties", Category = "Meat/Poultry", UnitPrice = 32.8000M, UnitsInStock = 0},
						new Product {ProductID = 54, ProductName = "Tourtière", Category = "Meat/Poultry", UnitPrice = 7.4500M, UnitsInStock = 21},
						new Product {ProductID = 55, ProductName = "Pâté chinois", Category = "Meat/Poultry", UnitPrice = 24.0000M, UnitsInStock = 115},
						new Product {ProductID = 56, ProductName = "Gnocchi di nonna Alice", Category = "Grains/Cereals", UnitPrice = 38.0000M, UnitsInStock = 21},
						new Product {ProductID = 57, ProductName = "Ravioli Angelo", Category = "Grains/Cereals", UnitPrice = 19.5000M, UnitsInStock = 36},
						new Product {ProductID = 58, ProductName = "Escargots de Bourgogne", Category = "Seafood", UnitPrice = 13.2500M, UnitsInStock = 62},
						new Product {ProductID = 59, ProductName = "Raclette Courdavault", Category = "Dairy Products", UnitPrice = 55.0000M, UnitsInStock = 79},
						new Product {ProductID = 60, ProductName = "Camembert Pierrot", Category = "Dairy Products", UnitPrice = 34.0000M, UnitsInStock = 19},
						new Product {ProductID = 61, ProductName = "Sirop d'érable", Category = "Condiments", UnitPrice = 28.5000M, UnitsInStock = 113},
						new Product {ProductID = 62, ProductName = "Tarte au sucre", Category = "Confections", UnitPrice = 49.3000M, UnitsInStock = 17},
						new Product {ProductID = 63, ProductName = "Vegie-spread", Category = "Condiments", UnitPrice = 43.9000M, UnitsInStock = 24},
						new Product {ProductID = 64, ProductName = "Wimmers gute Semmelknödel", Category = "Grains/Cereals", UnitPrice = 33.2500M, UnitsInStock = 22},
						new Product {ProductID = 65, ProductName = "Louisiana Fiery Hot Pepper Sauce", Category = "Condiments", UnitPrice = 21.0500M, UnitsInStock = 76},
						new Product {ProductID = 66, ProductName = "Louisiana Hot Spiced Okra", Category = "Condiments", UnitPrice = 17.0000M, UnitsInStock = 4},
						new Product {ProductID = 67, ProductName = "Laughing Lumberjack Lager", Category = "Beverages", UnitPrice = 14.0000M, UnitsInStock = 52},
						new Product {ProductID = 68, ProductName = "Scottish Longbreads", Category = "Confections", UnitPrice = 12.5000M, UnitsInStock = 6},
						new Product {ProductID = 69, ProductName = "Gudbrandsdalsost", Category = "Dairy Products", UnitPrice = 36.0000M, UnitsInStock = 26},
						new Product {ProductID = 70, ProductName = "Outback Lager", Category = "Beverages", UnitPrice = 15.0000M, UnitsInStock = 15},
						new Product {ProductID = 71, ProductName = "Flotemysost", Category = "Dairy Products", UnitPrice = 21.5000M, UnitsInStock = 26},
						new Product {ProductID = 72, ProductName = "Mozzarella di Giovanni", Category = "Dairy Products", UnitPrice = 34.8000M, UnitsInStock = 14},
						new Product {ProductID = 73, ProductName = "Röd Kaviar", Category = "Seafood", UnitPrice = 15.0000M, UnitsInStock = 101},
						new Product {ProductID = 74, ProductName = "Longlife Tofu", Category = "Produce", UnitPrice = 10.0000M, UnitsInStock = 4},
						new Product {ProductID = 75, ProductName = "Rhönbräu Klosterbier", Category = "Beverages", UnitPrice = 7.7500M, UnitsInStock = 125},
						new Product {ProductID = 76, ProductName = "Lakkalikööri", Category = "Beverages", UnitPrice = 18.0000M, UnitsInStock = 57},
						new Product {ProductID = 77, ProductName = "Original Frankfurter grüne Soße", Category = "Condiments", UnitPrice = 13.0000M, UnitsInStock = 32}
					};
		
	}
	        public class Product
        {
            public int ProductID { get; set; }
            public string ProductName { get; set; }
            public string Category { get; set; }
            public decimal UnitPrice { get; set; }
            public int UnitsInStock { get; set; }
        }


}

​x
 
using System;
using System.Linq;
using System.Collections.Generic;
​
                    
public class Program
{
    public static void Main()
    {
        var products = getList();
    
        var productGroups = products.GroupBy(p => p.Category)
            .Where(g => g.All(p => p.UnitsInStock > 0))
            .Select(g => new {Category = g.Key, Products = g});
            
        Console.WriteLine("Count before All : " + products.Count());
        
        int newCount = 0;
        
        foreach (var group in productGroups) 
        {
            newCount+= group.Products.Count();
        }
        
        Console.WriteLine("Count After All : " + newCount);
        
        foreach (var group in productGroups) 
        {
            Console.WriteLine(group.Category );
            
            foreach(var product in  group.Products) 
            {
                Console.WriteLine("ProductID = " + "ProductName : " + product.ProductName+ " Category : "  + product.Category+" UnitPrice : "  + product.UnitPrice+ " UnitPrice : "  + product.UnitPrice+" UnitsInStock : " + product.UnitsInStock);
            }
        }
    }
    
    public static List<Product> getList()
    {
        return  new List<Product>        {  new Product {ProductID = 1, ProductName = "Chai", Category = "Beverages", UnitPrice = 18.0000M, UnitsInStock = 39},
                        new Product {ProductID = 2, ProductName = "Chang", Category = "Beverages", UnitPrice = 19.0000M, UnitsInStock = 17},
                        new Product {ProductID = 3, ProductName = "Aniseed Syrup", Category = "Condiments", UnitPrice = 10.0000M, UnitsInStock = 13},
                        new Product {ProductID = 4, ProductName = "Chef Anton's Cajun Seasoning", Category = "Condiments", UnitPrice = 22.0000M, UnitsInStock = 53},
                        new Product {ProductID = 5, ProductName = "Chef Anton's Gumbo Mix", Category = "Condiments", UnitPrice = 21.3500M, UnitsInStock = 0},
                        new Product {ProductID = 6, ProductName = "Grandma's Boysenberry Spread", Category = "Condiments", UnitPrice = 25.0000M, UnitsInStock = 120},
                        new Product {ProductID = 7, ProductName = "Uncle Bob's Organic Dried Pears", Category = "Produce", UnitPrice = 30.0000M, UnitsInStock = 15},
                        new Product {ProductID = 8, ProductName = "Northwoods Cranberry Sauce", Category = "Condiments", UnitPrice = 40.0000M, UnitsInStock = 6},
                        new Product {ProductID = 9, ProductName = "Mishi Kobe Niku", Category = "Meat/Poultry", UnitPrice = 97.0000M, UnitsInStock = 29},
                        new Product {ProductID = 10, ProductName = "Ikura", Category = "Seafood", UnitPrice = 31.0000M, UnitsInStock = 31},
                        new Product {ProductID = 11, ProductName = "Queso Cabrales", Category = "Dairy Products", UnitPrice = 21.0000M, UnitsInStock = 22},
                        new Product {ProductID = 12, ProductName = "Queso Manchego La Pastora", Category = "Dairy Products", UnitPrice = 38.0000M, UnitsInStock = 86},
                        new Product {ProductID = 13, ProductName = "Konbu", Category = "Seafood", UnitPrice = 6.0000M, UnitsInStock = 24},
                        new Product {ProductID = 14, ProductName = "Tofu", Category = "Produce", UnitPrice = 23.2500M, UnitsInStock = 35},
                        new Product {ProductID = 15, ProductName = "Genen Shouyu", Category = "Condiments", UnitPrice = 15.5000M, UnitsInStock = 39},
                        new Product {ProductID = 16, ProductName = "Pavlova", Category = "Confections", UnitPrice = 17.4500M, UnitsInStock = 29},
                        new Product {ProductID = 17, ProductName = "Alice Mutton", Category = "Meat/Poultry", UnitPrice = 39.0000M, UnitsInStock = 0},
                        new Product {ProductID = 18, ProductName = "Carnarvon Tigers", Category = "Seafood", UnitPrice = 62.5000M, UnitsInStock = 42},
                        new Product {ProductID = 19, ProductName = "Teatime Chocolate Biscuits", Category = "Confections", UnitPrice = 9.2000M, UnitsInStock = 25},
                        new Product {ProductID = 20, ProductName = "Sir Rodney's Marmalade", Category = "Confections", UnitPrice = 81.0000M, UnitsInStock = 40},
                        new Product {ProductID = 21, ProductName = "Sir Rodney's Scones", Category = "Confections", UnitPrice = 10.0000M, UnitsInStock = 3},
                        new Product {ProductID = 22, ProductName = "Gustaf's Knäckebröd", Category = "Grains/Cereals", UnitPrice = 21.0000M, UnitsInStock = 104},
                        new Product {ProductID = 23, ProductName = "Tunnbröd", Category = "Grains/Cereals", UnitPrice = 9.0000M, UnitsInStock = 61},
                        new Product {ProductID = 24, ProductName = "Guaraná Fantástica", Category = "Beverages", UnitPrice = 4.5000M, UnitsInStock = 20},
                        new Product {ProductID = 25, ProductName = "NuNuCa Nuß-Nougat-Creme", Category = "Confections", UnitPrice = 14.0000M, UnitsInStock = 76},
                        new Product {ProductID = 26, ProductName = "Gumbär Gummibärchen", Category = "Confections", UnitPrice = 31.2300M, UnitsInStock = 15},
                        new Product {ProductID = 27, ProductName = "Schoggi Schokolade", Category = "Confections", UnitPrice = 43.9000M, UnitsInStock = 49},
                        new Product {ProductID = 28, ProductName = "Rössle Sauerkraut", Category = "Produce", UnitPrice = 45.6000M, UnitsInStock = 26},
                        new Product {ProductID = 29, ProductName = "Thüringer Rostbratwurst", Category = "Meat/Poultry", UnitPrice = 123.7900M, UnitsInStock = 0},
                        new Product {ProductID = 30, ProductName = "Nord-Ost Matjeshering", Category = "Seafood", UnitPrice = 25.8900M, UnitsInStock = 10},
                        new Product {ProductID = 31, ProductName = "Gorgonzola Telino", Category = "Dairy Products", UnitPrice = 12.5000M, UnitsInStock = 0},
                        new Product {ProductID = 32, ProductName = "Mascarpone Fabioli", Category = "Dairy Products", UnitPrice = 32.0000M, UnitsInStock = 9},
                        new Product {ProductID = 33, ProductName = "Geitost", Category = "Dairy Products", UnitPrice = 2.5000M, UnitsInStock = 112},
                        new Product {ProductID = 34, ProductName = "Sasquatch Ale", Category = "Beverages", UnitPrice = 14.0000M, UnitsInStock = 111},
                        new Product {ProductID = 35, ProductName = "Steeleye Stout", Category = "Beverages", UnitPrice = 18.0000M, UnitsInStock = 20},
                        new Product {ProductID = 36, ProductName = "Inlagd Sill", Category = "Seafood", UnitPrice = 19.0000M, UnitsInStock = 112},
                        new Product {ProductID = 37, ProductName = "Gravad lax", Category = "Seafood", UnitPrice = 26.0000M, UnitsInStock = 11},
                        new Product {ProductID = 38, ProductName = "Côte de Blaye", Category = "Beverages", UnitPrice = 263.5000M, UnitsInStock = 17},
                        new Product {ProductID = 39, ProductName = "Chartreuse verte", Category = "Beverages", UnitPrice = 18.0000M, UnitsInStock = 69},
                        new Product {ProductID = 40, ProductName = "Boston Crab Meat", Category = "Seafood", UnitPrice = 18.4000M, UnitsInStock = 123},
                        new Product {ProductID = 41, ProductName = "Jack's New England Clam Chowder", Category = "Seafood", UnitPrice = 9.6500M, UnitsInStock = 85},
                        new Product {ProductID = 42, ProductName = "Singaporean Hokkien Fried Mee", Category = "Grains/Cereals", UnitPrice = 14.0000M, UnitsInStock = 26},
                        new Product {ProductID = 43, ProductName = "Ipoh Coffee", Category = "Beverages", UnitPrice = 46.0000M, UnitsInStock = 17},
                        new Product {ProductID = 44, ProductName = "Gula Malacca", Category = "Condiments", UnitPrice = 19.4500M, UnitsInStock = 27},
                        new Product {ProductID = 45, ProductName = "Rogede sild", Category = "Seafood", UnitPrice = 9.5000M, UnitsInStock = 5},
                        new Product {ProductID = 46, ProductName = "Spegesild", Category = "Seafood", UnitPrice = 12.0000M, UnitsInStock = 95},
                        new Product {ProductID = 47, ProductName = "Zaanse koeken", Category = "Confections", UnitPrice = 9.5000M, UnitsInStock = 36},
                        new Product {ProductID = 48, ProductName = "Chocolade", Category = "Confections", UnitPrice = 12.7500M, UnitsInStock = 15},
                        new Product {ProductID = 49, ProductName = "Maxilaku", Category = "Confections", UnitPrice = 20.0000M, UnitsInStock = 10},
                        new Product {ProductID = 50, ProductName = "Valkoinen suklaa", Category = "Confections", UnitPrice = 16.2500M, UnitsInStock = 65},
                        new Product {ProductID = 51, ProductName = "Manjimup Dried Apples", Category = "Produce", UnitPrice = 53.0000M, UnitsInStock = 20},
                        new Product {ProductID = 52, ProductName = "Filo Mix", Category = "Grains/Cereals", UnitPrice = 7.0000M, UnitsInStock = 38},
                        new Product {ProductID = 53, ProductName = "Perth Pasties", Category = "Meat/Poultry", UnitPrice = 32.8000M, UnitsInStock = 0},
                        new Product {ProductID = 54, ProductName = "Tourtière", Category = "Meat/Poultry", UnitPrice = 7.4500M, UnitsInStock = 21},
                        new Product {ProductID = 55, ProductName = "Pâté chinois", Category = "Meat/Poultry", UnitPrice = 24.0000M, UnitsInStock = 115},
                        new Product {ProductID = 56, ProductName = "Gnocchi di nonna Alice", Category = "Grains/Cereals", UnitPrice = 38.0000M, UnitsInStock = 21},
                        new Product {ProductID = 57, ProductName = "Ravioli Angelo", Category = "Grains/Cereals", UnitPrice = 19.5000M, UnitsInStock = 36},
                        new Product {ProductID = 58, ProductName = "Escargots de Bourgogne", Category = "Seafood", UnitPrice = 13.2500M, UnitsInStock = 62},
                        new Product {ProductID = 59, ProductName = "Raclette Courdavault", Category = "Dairy Products", UnitPrice = 55.0000M, UnitsInStock = 79},
                        new Product {ProductID = 60, ProductName = "Camembert Pierrot", Category = "Dairy Products", UnitPrice = 34.0000M, UnitsInStock = 19},
                        new Product {ProductID = 61, ProductName = "Sirop d'érable", Category = "Condiments", UnitPrice = 28.5000M, UnitsInStock = 113},
                        new Product {ProductID = 62, ProductName = "Tarte au sucre", Category = "Confections", UnitPrice = 49.3000M, UnitsInStock = 17},
                        new Product {ProductID = 63, ProductName = "Vegie-spread", Category = "Condiments", UnitPrice = 43.9000M, UnitsInStock = 24},
                        new Product {ProductID = 64, ProductName = "Wimmers gute Semmelknödel", Category = "Grains/Cereals", UnitPrice = 33.2500M, UnitsInStock = 22},
                        new Product {ProductID = 65, ProductName = "Louisiana Fiery Hot Pepper Sauce", Category = "Condiments", UnitPrice = 21.0500M, UnitsInStock = 76},
                        new Product {ProductID = 66, ProductName = "Louisiana Hot Spiced Okra", Category = "Condiments", UnitPrice = 17.0000M, UnitsInStock = 4},
                        new Product {ProductID = 67, ProductName = "Laughing Lumberjack Lager", Category = "Beverages", UnitPrice = 14.0000M, UnitsInStock = 52},
                        new Product {ProductID = 68, ProductName = "Scottish Longbreads", Category = "Confections", UnitPrice = 12.5000M, UnitsInStock = 6},
                        new Product {ProductID = 69, ProductName = "Gudbrandsdalsost", Category = "Dairy Products", UnitPrice = 36.0000M, UnitsInStock = 26},
                        new Product {ProductID = 70, ProductName = "Outback Lager", Category = "Beverages", UnitPrice = 15.0000M, UnitsInStock = 15},
                        new Product {ProductID = 71, ProductName = "Flotemysost", Category = "Dairy Products", UnitPrice = 21.5000M, UnitsInStock = 26},
                        new Product {ProductID = 72, ProductName = "Mozzarella di Giovanni", Category = "Dairy Products", UnitPrice = 34.8000M, UnitsInStock = 14},
                        new Product {ProductID = 73, ProductName = "Röd Kaviar", Category = "Seafood", UnitPrice = 15.0000M, UnitsInStock = 101},
                        new Product {ProductID = 74, ProductName = "Longlife Tofu", Category = "Produce", UnitPrice = 10.0000M, UnitsInStock = 4},
                        new Product {ProductID = 75, ProductName = "Rhönbräu Klosterbier", Category = "Beverages", UnitPrice = 7.7500M, UnitsInStock = 125},
                        new Product {ProductID = 76, ProductName = "Lakkalikööri", Category = "Beverages", UnitPrice = 18.0000M, UnitsInStock = 57},
                        new Product {ProductID = 77, ProductName = "Original Frankfurter grüne Soße", Category = "Condiments", UnitPrice = 13.0000M, UnitsInStock = 32}
                    };
        
    }
            public class Product
        {
            public int ProductID { get; set; }
            public string ProductName { get; set; }
            public string Category { get; set; }
            public decimal UnitPrice { get; set; }
            public int UnitsInStock { get; set; }
        }
​
​
}

Count before All : 77
Count After All : 49
Beverages
ProductID = ProductName : Chai Category : Beverages UnitPrice : 18.0000 UnitPrice : 18.0000 UnitsInStock : 39
ProductID = ProductName : Chang Category : Beverages UnitPrice : 19.0000 UnitPrice : 19.0000 UnitsInStock : 17
ProductID = ProductName : Guaraná Fantástica Category : Beverages UnitPrice : 4.5000 UnitPrice : 4.5000 UnitsInStock : 20
ProductID = ProductName : Sasquatch Ale Category : Beverages UnitPrice : 14.0000 UnitPrice : 14.0000 UnitsInStock : 111
ProductID = ProductName : Steeleye Stout Category : Beverages UnitPrice : 18.0000 UnitPrice : 18.0000 UnitsInStock : 20
ProductID = ProductName : Côte de Blaye Category : Beverages UnitPrice : 263.5000 UnitPrice : 263.5000 UnitsInStock : 17
ProductID = ProductName : Chartreuse verte Category : Beverages UnitPrice : 18.0000 UnitPrice : 18.0000 UnitsInStock : 69
ProductID = ProductName : Ipoh Coffee Category : Beverages UnitPrice : 46.0000 UnitPrice : 46.0000 UnitsInStock : 17
ProductID = ProductName : Laughing Lumberjack Lager Category : Beverages UnitPrice : 14.0000 UnitPrice : 14.0000 UnitsInStock : 52
ProductID = ProductName : Outback Lager Category : Beverages UnitPrice : 15.0000 UnitPrice : 15.0000 UnitsInStock : 15
ProductID = ProductName : Rhönbräu Klosterbier Category : Beverages UnitPrice : 7.7500 UnitPrice : 7.7500 UnitsInStock : 125
ProductID = ProductName : Lakkalikööri Category : Beverages UnitPrice : 18.0000 UnitPrice : 18.0000 UnitsInStock : 57
Produce
ProductID = ProductName : Uncle Bob's Organic Dried Pears Category : Produce UnitPrice : 30.0000 UnitPrice : 30.0000 UnitsInStock : 15
ProductID = ProductName : Tofu Category : Produce UnitPrice : 23.2500 UnitPrice : 23.2500 UnitsInStock : 35
ProductID = ProductName : Rössle Sauerkraut Category : Produce UnitPrice : 45.6000 UnitPrice : 45.6000 UnitsInStock : 26
ProductID = ProductName : Manjimup Dried Apples Category : Produce UnitPrice : 53.0000 UnitPrice : 53.0000 UnitsInStock : 20
ProductID = ProductName : Longlife Tofu Category : Produce UnitPrice : 10.0000 UnitPrice : 10.0000 UnitsInStock : 4
Seafood
ProductID = ProductName : Ikura Category : Seafood UnitPrice : 31.0000 UnitPrice : 31.0000 UnitsInStock : 31
ProductID = ProductName : Konbu Category : Seafood UnitPrice : 6.0000 UnitPrice : 6.0000 UnitsInStock : 24
ProductID = ProductName : Carnarvon Tigers Category : Seafood UnitPrice : 62.5000 UnitPrice : 62.5000 UnitsInStock : 42
ProductID = ProductName : Nord-Ost Matjeshering Category : Seafood UnitPrice : 25.8900 UnitPrice : 25.8900 UnitsInStock : 10
ProductID = ProductName : Inlagd Sill Category : Seafood UnitPrice : 19.0000 UnitPrice : 19.0000 UnitsInStock : 112
ProductID = ProductName : Gravad lax Category : Seafood UnitPrice : 26.0000 UnitPrice : 26.0000 UnitsInStock : 11
ProductID = ProductName : Boston Crab Meat Category : Seafood UnitPrice : 18.4000 UnitPrice : 18.4000 UnitsInStock : 123
ProductID = ProductName : Jack's New England Clam Chowder Category : Seafood UnitPrice : 9.6500 UnitPrice : 9.6500 UnitsInStock : 85
ProductID = ProductName : Rogede sild Category : Seafood UnitPrice : 9.5000 UnitPrice : 9.5000 UnitsInStock : 5
ProductID = ProductName : Spegesild Category : Seafood UnitPrice : 12.0000 UnitPrice : 12.0000 UnitsInStock : 95
ProductID = ProductName : Escargots de Bourgogne Category : Seafood UnitPrice : 13.2500 UnitPrice : 13.2500 UnitsInStock : 62
ProductID = ProductName : Röd Kaviar Category : Seafood UnitPrice : 15.0000 UnitPrice : 15.0000 UnitsInStock : 101
Confections
ProductID = ProductName : Pavlova Category : Confections UnitPrice : 17.4500 UnitPrice : 17.4500 UnitsInStock : 29
ProductID = ProductName : Teatime Chocolate Biscuits Category : Confections UnitPrice : 9.2000 UnitPrice : 9.2000 UnitsInStock : 25
ProductID = ProductName : Sir Rodney's Marmalade Category : Confections UnitPrice : 81.0000 UnitPrice : 81.0000 UnitsInStock : 40
ProductID = ProductName : Sir Rodney's Scones Category : Confections UnitPrice : 10.0000 UnitPrice : 10.0000 UnitsInStock : 3
ProductID = ProductName : NuNuCa Nuß-Nougat-Creme Category : Confections UnitPrice : 14.0000 UnitPrice : 14.0000 UnitsInStock : 76
ProductID = ProductName : Gumbär Gummibärchen Category : Confections UnitPrice : 31.2300 UnitPrice : 31.2300 UnitsInStock : 15
ProductID = ProductName : Schoggi Schokolade Category : Confections UnitPrice : 43.9000 UnitPrice : 43.9000 UnitsInStock : 49
ProductID = ProductName : Zaanse koeken Category : Confections UnitPrice : 9.5000 UnitPrice : 9.5000 UnitsInStock : 36
ProductID = ProductName : Chocolade Category : Confections UnitPrice : 12.7500 UnitPrice : 12.7500 UnitsInStock : 15
ProductID = ProductName : Maxilaku Category : Confections UnitPrice : 20.0000 UnitPrice : 20.0000 UnitsInStock : 10
ProductID = ProductName : Valkoinen suklaa Category : Confections UnitPrice : 16.2500 UnitPrice : 16.2500 UnitsInStock : 65
ProductID = ProductName : Tarte au sucre Category : Confections UnitPrice : 49.3000 UnitPrice : 49.3000 UnitsInStock : 17
ProductID = ProductName : Scottish Longbreads Category : Confections UnitPrice : 12.5000 UnitPrice : 12.5000 UnitsInStock : 6
Grains/Cereals
ProductID = ProductName : Gustaf's Knäckebröd Category : Grains/Cereals UnitPrice : 21.0000 UnitPrice : 21.0000 UnitsInStock : 104
ProductID = ProductName : Tunnbröd Category : Grains/Cereals UnitPrice : 9.0000 UnitPrice : 9.0000 UnitsInStock : 61
ProductID = ProductName : Singaporean Hokkien Fried Mee Category : Grains/Cereals UnitPrice : 14.0000 UnitPrice : 14.0000 UnitsInStock : 26
ProductID = ProductName : Filo Mix Category : Grains/Cereals UnitPrice : 7.0000 UnitPrice : 7.0000 UnitsInStock : 38
ProductID = ProductName : Gnocchi di nonna Alice Category : Grains/Cereals UnitPrice : 38.0000 UnitPrice : 38.0000 UnitsInStock : 21
ProductID = ProductName : Ravioli Angelo Category : Grains/Cereals UnitPrice : 19.5000 UnitPrice : 19.5000 UnitsInStock : 36
ProductID = ProductName : Wimmers gute Semmelknödel Category : Grains/Cereals UnitPrice : 33.2500 UnitPrice : 33.2500 UnitsInStock : 22

Cached Result
Last Run:	5:57:00 pm
Compile:	0.11s
Execute:	0.016s
Memory:	98.48kb
CPU:	0.031s

View IL Code