C# 5.0 Unleashed

Ordering

One of the most commonly used query operations in the world of databases is applying ordering to the elements or records. Obviously, LINQ provides for this, as well:

Click here to view code image

var memoryHungry = from process in Process.GetProcesses()                   orderby process.ProcessName, process.WorkingSet64 descending                   select process;

The preceding query expression translates into the use of two operators, OrderBy and ThenByDescending. Their respective roles will become apparent in just a moment:

Click here to view code image

var memoryHungry = Process.GetProcesses()                   .OrderBy(process => process.ProcessName)                   .ThenByDescending(process => process.WorkingSet64);

OrderBy and ...