Link for all dot net and sql server video tutorial playlists
Link for slides, code samples and text version of the video
The following 5 standard LINQ query operators belong to Ordering Operators category
OrderBy
OrderByDescending
ThenBy
ThenByDescending
Reverse
OrderBy, OrderByDescending, ThenBy, and ThenByDescending can be used to sort data. Reverse method simply reverses the items in a given collection.
Example 1: Sort Students by Name in ascending order
IEnumerable[Student] result = Student.GetAllStudents().OrderBy(s =] s.Name);
foreach (Student student in result)
{
Console.WriteLine(student.Name);
}
Example 2: Rewrite Example 1 using SQL like syntax
IEnumerable[Student] result = from student in Student.GetAllStudents()
orderby student.Name
select student;
foreach (Student student in result)
{
Console.WriteLine(student.Name);
}
Example 3: Sort Students by Name in descending order
IEnumerable[Student] result = Student.GetAllStudents().OrderByDescending(s =] s.Name);
foreach (Student student in result)
{
Console.WriteLine(student.Name);
}
Example 4: Rewrite Example 3 using SQL like syntax
IEnumerable[Student] result = from student in Student.GetAllStudents()
orderby student.Name descending
select student;
foreach (Student student in result)
{
Console.WriteLine(student.Name);
}
