C# and LINQ : Groups, Join, Paging, and Neted LINQ Queries

string[] currentVideoGames = {"Morrowind", "BioShock", "Half Life 2"};

            // Build a query expression using extension methods

            // granted to the Array via the Enumerable type.

Sorting Results:

            from game in currentVideGames

            where game.length > 5

            descending

            select game

Grouping Results:

            from game in currentVideGames

            where game.length > 5

            group game by game into gamegroup

            select gamegroups;

now get group list;

            from gamegroup in gamegroups

            select new {gamegroup.key, gamegroup.Count() }

Outer Join:

            var data = from c in customers

                                    join o in (   from orderInJan97 in orders

                                                            where orderInJan97.OrderDate.Value.Year == 1997

                                                            && orderInJan97.OrderDate.Value.Month == 1

                                                            select orderInJan97

                                                    )

                                    on c.CustomerID equals o.CustomerID into groupOrders

                                    select new { c.CompanyName,OrderTotal = groupOrders.Count()                                                                                                                                                             };

Partioning and Paging:

            var data = ( from c in customers

                                     select c).Take(10);

            var data = (from c in customers

                                     select c). Skip(30). Take(10);

           

Nested Queries:

            only having length 5 - 10

            (from game in currentVideGames

            where game.length > 5

            select game

            ).Except

                             (

                                    from game

                                    where game.length >10

                                    select game

                              );