.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> LINQ >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Filtering and Sorting : LINQ to Object Part 2

Posted By:Dhananjay Kumar       Posted Date: March 21, 2010    Points: 25    Category: LINQ    URL: http://www.dotnetspark.com  

Filtering and Sorting : LINQ to Object Part 2. In this article, I am going to show you how we can achieve filtering and sorting using LINQ to object.
 

Introduction

In this article, I am going to show you how we can achieve filtering and sorting using LINQ to object.Here is the first part

I have created two classes for explanation purposes, Student and Hostel. The Student class has details about a student and the Hostel class has details about a hostel. Both classes have the property HostelNumber in common. I will be using this property to perform join operations in later articles. Both classes are shown below.

Student.cs

namespace LINQtoOBJECT1
{
  public  class Student
  { 
  public int HostelNumber { get; set; }
  public int RollNumber { get; set; }
  public string Name { get; set; }
  public int Section { get; set; }
  }
}

Hostel.cs

namespace LINQtoOBJECT1
{
  public class Hostel
  {
 
  public int HostelNumber { get; set; }
  public int NumberofRooms { get; set; }
  }
}


To create and obtain collections of students and hostels, I have created two static functions: GetStudents
and GetHostel .

Function to return collection of students

static List GetStudents()
{
  List students = new List
  {
  new Student() { RollNumber = 1,Name ="Alex " , Section = 1 ,HostelNumber=1 },
  new Student() { RollNumber = 2,Name ="Jonty " , Section = 2 ,HostelNumber=2 },
  new Student() { RollNumber = 3,Name ="Samba " , Section = 3 ,HostelNumber=1 },
  new Student() { RollNumber = 4,Name ="Donald " , Section = 3 ,HostelNumber=2 },
  new Student() { RollNumber = 5,Name ="Kristen " , Section = 2 ,HostelNumber=1 },
  new Student() { RollNumber = 6,Name ="Mark " , Section = 1 ,HostelNumber=2},
  new Student() { RollNumber = 8,Name ="Peterson " , Section = 2 ,HostelNumber=2 },
  new Student() { RollNumber = 9,Name ="collingwood " , Section = 3 ,HostelNumber=1 },
  new Student() { RollNumber = 10,Name ="Brian " , Section = 3 ,HostelNumber=2 }
 
  };
 
  return students; 
  
}

Function to return collection of hostels

static List GetHostel()
{
  List hostels = new List
  {
 
  new Hostel(){HostelNumber=1 ,NumberofRooms = 100},
  new Hostel(){HostelNumber= 2 ,NumberofRooms = 200}
  };
  return hostels; 
}


Now have a look at both code fragments below.  One is using LINQ and the other is using a loop to retrieve and print data from the list.

Note: I will be using the two classes(Student and Hostel) and corresponding functions(GetStudents and GetHostel) for my entire sample below.

Filtering in LINQ

image1.gif

In the code below, I am filtering the result. I am only fetching details from the student with RollNumber = 1.

List lstStudents = GetStudents();
  Student student = (from r in lstStudents where r.RollNumber == 1 select r).First();  
  Console.WriteLine(student.Name + student.RollNumber  + student.HostelNumber + student.Section); 

If you examine the LINQ query closely, I am using the First extension method in order to return a single Student. Without the First extension, the default return type for a LINQ query is IEnumerable. If I modify the LINQ statement above by removing the First extension,

Student student = (from r in lstStudents where r.RollNumber == 1 select r);

At compile time we can expect the error shown below:

image2.gif

When we run the code containing the First extension above, we get the following output:

Output

image3.gif

Let's say I want to retrieve the names of all the students whose roll number is more than 3 and who resides in hostel number 2.  We can alter our LINQ query where clause to include these conditions:

List lstStudents = GetStudents();
IEnumerable lstStudentName = from r in lstStudents where r.RollNumber > 3 &&  
r.HostelNumber== 2 select r.Name ;
foreach (string name in lstStudentName)
Console.WriteLine(name);

In above LINQ query, I am applying both filtering and projection.  The filter is the condition in the where clause that produces a subset of my initial student collection lstStudents.  Projection is the select clause which maps the result set of students to the result set of student names.

Output

image4.gif

Intermediate values

If I want to have intermediate values in my LINQ query then we introduce the LET clause into action. The LET clause helps us to reduce redundancy in the WHERE clause by allowing us to substitute a variable for an element of the LINQ statement.

IEnumerable lstStudentName = from r in lstStudents let condition = r.RollNumber  where condition > 3 && r.HostelNumber== 2 select r.Name ;

The Let clause can have even more complex statements than the simple example shown above, making our LINQ query more readable.

Sorting in LINQ

The OrderBy clause is used for purpose of sorting in LINQ.  Let's examine an example of using OrderBy in our LINQ query:
 

Sorting a single property

The OrderBy clause is used directly before the where clause in order to sort the query result. In the LINQ code shown below, the name of the students will be displayed alphabetically in ascending order.

List lstStudents = GetStudents();
  IEnumerable lstStudentName = from r in lstStudents let condition = r.RollNumber orderby r.Name  where condition > 3 && r.HostelNumber== 2 select r.Name ;
  foreach (string name in lstStudentName)
  Console.WriteLine(name);

Output

image5.gif

Sorting multiple properties

By putting commas between properties of a student in the OrderBy clause, we can achieve primary and secondary sorting. Sorting will be done left to right. Because I want to sort the roll number property in descending order, I'll use the descending keyword in my LINQ statement.  Sorting is performed in ascending order by default.
 
List lstStudents = GetStudents();
  IEnumerable lstStudentName = from r in lstStudents let condition = r.RollNumber orderby r.Name,r.RollNumber descending  where condition > 3 && r.HostelNumber== 2 select r ;
  foreach (Student  name in lstStudentName)
  Console.WriteLine(name.RollNumber + name.Name);

image6.gif

Conclusion

In the next article on this topic, I will explain Grouping using LINQ. I hope this article was useful to you in helping you understand some of the features of LINQ technology. Thanks for reading!

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend