public void Linq9()

{

    string[] words = { "aPPLE", "BlUeBeRrY", "cHeRry" }; 

    var upperLowerWords =

        from w in words

        select new { Upper = w.ToUpper(), Lower = w.ToLower() }; 

    foreach (var ul in upperLowerWords)

    {

        Console.WriteLine("Uppercase: {0}, Lowercase: {1}", ul.Upper, ul.Lower);

    }

}

public void Linq10()

{

    int[] numbers = { , , , , , , , , ,  };

    string[] strings = { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" }; 

    var digitOddEvens =

        from n in numbers

        select new { Digit = strings[n], Even = (n %  == ) }; 

    foreach (var d in digitOddEvens)

    {

        Console.WriteLine("The digit {0} is {1}.", d.Digit, d.Even ? "even" : "odd");

    }

}

public void Linq11()

{

    List<Product> products = GetProductList(); 

    var productInfos =

        from p in products

        select new { p.ProductName, p.Category, Price = p.UnitPrice }; 

    Console.WriteLine("Product Info:");

    foreach (var productInfo in productInfos)

    {

        Console.WriteLine("{0} is in the category {1} and costs {2} per unit.", productInfo.ProductName, productInfo.Category, productInfo.Price);

    }

}

public void Linq12()

{

    int[] numbers = { , , , , , , , , ,  }; 

    var numsInPlace = numbers.Select((num, index) => new { Num = num, InPlace = (num == index) }); 

    Console.WriteLine("Number: In-place?");

    foreach (var n in numsInPlace)

    {

        Console.WriteLine("{0}: {1}", n.Num, n.InPlace);

    }

}

Result

Number: In-place?
5: False
4: False
1: False
3: True
9: False
8: False
6: True
7: True
2: False
0: False

Select - Filtered

public void Linq13()

{

    int[] numbers = { , , , , , , , , ,  };

    string[] digits = { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" }; 

    var lowNums =

        from n in numbers

        where n <

        select digits[n]; 

    Console.WriteLine("Numbers < 5:");

    foreach (var num in lowNums)

    {

        Console.WriteLine(num);

    }

}

Result

Numbers < 5:
four
one
three
two
zero

SelectMany - Compound from 1

public void Linq14()

{

    int[] numbersA = { , , , , , ,  };

    int[] numbersB = { , , , ,  }; 

    var pairs =

        from a in numbersA

        from b in numbersB

        where a < b

        select new { a, b }; 

    Console.WriteLine("Pairs where a < b:");

    foreach (var pair in pairs)

    {

        Console.WriteLine("{0} is less than {1}", pair.a, pair.b);

    }

}

Result

Pairs where a < b:
0 is less than 1
0 is less than 3
0 is less than 5
0 is less than 7
0 is less than 8
2 is less than 3
2 is less than 5
2 is less than 7
2 is less than 8
4 is less than 5
4 is less than 7
4 is less than 8
5 is less than 7
5 is less than 8
6 is less than 7
6 is less than 8

SelectMany - Compound from 2

public void Linq15()

{

    List<Customer> customers = GetCustomerList(); 

    var orders =

        from c in customers

        from o in c.Orders

        where o.Total < 500.00M

        select new { c.CustomerID, o.OrderID, o.Total }; 

    ObjectDumper.Write(orders);

}

Result

CustomerID=ALFKI OrderID=10702 Total=330.00
CustomerID=ALFKI OrderID=10952 Total=471.20
CustomerID=ANATR OrderID=10308 Total=88.80
CustomerID=ANATR OrderID=10625 Total=479.75
CustomerID=ANATR OrderID=10759 Total=320.00
CustomerID=ANTON OrderID=10365 Total=403.20
CustomerID=ANTON OrderID=10682 Total=375.50
CustomerID=AROUT OrderID=10355 Total=480.00

SelectMany - Compound from 3

public void Linq16()

{

    List<Customer> customers = GetCustomerList(); 

    var orders =

        from c in customers

        from o in c.Orders

        where o.OrderDate >= new DateTime(, , )

        select new { c.CustomerID, o.OrderID, o.OrderDate }; 

    ObjectDumper.Write(orders);

}

public void Linq17()

{

    List<Customer> customers = GetCustomerList(); 

    var orders =

        from c in customers

        from o in c.Orders

        where o.Total >= 2000.0M

        select new { c.CustomerID, o.OrderID, o.Total }; 

    ObjectDumper.Write(orders);

}

public void Linq18()

{

    List<Customer> customers = GetCustomerList(); 

    DateTime cutoffDate = new DateTime(, , ); 

    var orders =

        from c in customers

        where c.Region == "WA"

        from o in c.Orders

        where o.OrderDate >= cutoffDate

        select new { c.CustomerID, o.OrderID }; 

    ObjectDumper.Write(orders);

}

public void Linq19()

{

    List<Customer> customers = GetCustomerList(); 

    var customerOrders =

        customers.SelectMany(

            (cust, custIndex) =>

            cust.Orders.Select(o => "Customer #" + (custIndex + ) +

                                    " has an order with OrderID " + o.OrderID)); 

    ObjectDumper.Write(customerOrders);

}