public void Linq1()
{
    int  []   numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
 
    var lowNums =
        from n in numbers
        where n < 5
        select n;
 
    Console.WriteLine("Numbers < 5:");
    foreach (var x in lowNums)
    {
        Console.WriteLine(x);
    }
}

public void Linq2()
{
    List<Product> products = GetProductList();
 
    var soldOutProducts =
        from p in products
        where p.UnitsInStock == 0
        select p;
 
    Console.WriteLine("Sold out products:");
    foreach (var product in soldOutProducts)
    {
        Console.WriteLine("{0} is sold out!", product.ProductName);
    }
}

public void Linq6()
{
    int  []   numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
 
    var numsPlusOne =
        from n in numbers
        select n + 1;
 
    Console.WriteLine("Numbers + 1:");
    foreach (var i in numsPlusOne)
    {
        Console.WriteLine(i);
    }
}

public void Linq28()
{
    string  []   words = { "cherry", "apple", "blueberry" };
 
    var sortedWords =
        from w in words
        orderby w
        select w;
 
    Console.WriteLine("The sorted list of words:");
    foreach (var w in sortedWords)
    {
        Console.WriteLine(w);
    }
}

public void Linq32()
{
    double  []   doubles = { 1.7, 2.3, 1.9, 4.1, 2.9 };
 
    var sortedDoubles =
        from d in doubles
        orderby d descending
        select d;
 
    Console.WriteLine("The doubles from highest to lowest:");
    foreach (var d in sortedDoubles)
    {
        Console.WriteLine(d);
    }
}

public void Linq102()
 
{
 
    string    []     categories = new string    []    { 
 
        "Beverages", 
 
        "Condiments", 
 
        "Vegetables", 
 
        "Dairy Products", 
 
        "Seafood" };
 
 
 
    List<Product> products = GetProductList();
 
 
 
    var q =
 
        from c in categories
 
        join p in products on c equals p.Category
 
        select new { Category = c, p.ProductName };
 
 
 
    foreach (var v in q)
 
    {
 
        Console.WriteLine(v.ProductName + ": " + v.Category);
 
    }
 
}