Click here to Skip to main content
Click here to Skip to main content

Generic Sorting with LINQ and Lambda Expressions

By , 24 Jun 2009
 

Introduction

Sorting objects has been a programming problem that has gone from a science to a mere few lines of code. Though it does not take nearly the amount of consideration as it did before my time in the industry, it's still just as relevant. This article takes a look at sorting using Lambda Expressions and Generics. In my opinion, the best technique for sorting objects that I have seen so far. This class has found a definite home in my Utils assembly, and so I share it with you.

Background

As programmers, it is always our duty, and pleasure, to find better ways to the same thing. That is how I stumbled on this sorting technique. I was working on a project that had several grids that required paging and sorting, and like many projects, we were using an object model. I was thinking that I wanted a generic sorting class that did all the work in one place, and this article shares the results.

Using the code

These samples have been dumped down a little from my actual implementation to improve readability for the purposes of this article. After reviewing this code though, I am confident that you will be able to think of several slick uses for this technique like I have.

Usage of the sorting class

C#:

GenericSorter<surveystateformatdata> gs = new GenericSorter<surveystateformatdata >();
SurveyStateFormatItems = gs.Sort(SurveyStateFormatItems.AsQueryable, 
                                 sortExpression, sortDirection).ToArray();

VB.NET:

Dim gs As New GenericSorter(Of SurveyStateFormatData)
SurveyStateFormatItems = gs.Sort(SurveyStateFormatItems.AsQueryable, _
                                 sortExpression, sortDirection).ToArray()

Here is the sorting class:

C#:

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Linq.Expressions; 


public class GenericSorter<T>
{
    public IEnumerable<T> Sort(IEnumerable<T> source, string sortBy, string sortDirection)
    {
        var param = Expression.Parameter(typeof(T), "item");

        var sortExpression = Expression.Lambda<Func<T, object>>
            (Expression.Convert(Expression.Property(param, sortBy), typeof(object)), param);

        switch (sortDirection.ToLower())
        {
            case "asc":
                return source.AsQueryable<T>().OrderBy<T, object>(sortExpression);
            default:
                return source.AsQueryable<T>().OrderByDescending<T, object>(sortExpression);

        } 
    }
}

VB.NET:

Imports System
Imports System.Collections.Generic
Imports System.Linq
Imports System.Linq.Expressions

Public Class GenericSorter(Of T)

    Public Function Sort(ByVal source As IEnumerable(Of T), _
                         ByVal sortBy As String, _
                         ByVal sortDirection As String) As IEnumerable(Of T)

        Dim param = Expression.Parameter(GetType(T), "item")

        Dim sortExpression = Expression.Lambda(Of Func(Of T, Object))_
        (Expression.Convert(Expression.[Property](param, sortBy), _
        GetType(Object)), param)

        Select Case sortDirection.ToLower
            Case "asc"
                Return source.AsQueryable().OrderBy(sortExpression)
            Case Else
                Return source.AsQueryable().OrderByDescending(sortExpression)
        End Select

    End Function

End Class

History

  • Article added: (06/22/2009).

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

AdamNThompson
Web Developer
United States United States
Member
No Biography provided

Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page   
QuestionHow to sort a Collection base on a given dynamic sort field string list PinmemberMember 412087022 Nov '12 - 15:18 
AnswerRe: How to sort a Collection base on a given dynamic sort field string list PinmemberAdamNThompson3 Dec '12 - 4:05 
QuestionPerformance Pinmemberrickoshay29 Jun '09 - 9:39 
AnswerRe: Performance PinmemberAdamNThompson30 Jun '09 - 8:27 
GeneralThis is a neat concept, but example does not compile. PinmemberMichael Lee Yohe23 Jun '09 - 9:21 
GeneralRe: This is a neat concept, but example does not compile. PinmemberAdamNThompson23 Jun '09 - 11:20 
GeneralFigured it out with some modifications to the C# version: PinmemberMichael Lee Yohe23 Jun '09 - 11:43 
GeneralRe: Figured it out with some modifications to the C# version: PinmemberAdamNThompson23 Jun '09 - 12:01 
GeneralRe: Figured it out with some modifications to the C# version: PinmemberMichael Lee Yohe24 Jun '09 - 4:45 
GeneralRe: Figured it out with some modifications to the C# version: Pinmemberrxm020325 Jun '09 - 7:07 
GeneralRe: Figured it out with some modifications to the C# version: [modified] PinmemberSchmuli30 Jun '09 - 0:14 
GeneralRe: Figured it out with some modifications to the C# version: PinmemberSchmuli30 Jun '09 - 0:55 
GeneralRe: Figured it out with some modifications to the C# version: PinmemberAdamNThompson30 Jun '09 - 8:37 
GeneralRe: Figured it out with some modifications to the C# version: Pinmemberpavilp15 Jun '10 - 2:03 
GeneralRe: Figured it out with some modifications to the C# version: PinmemberAdamNThompson21 Jun '10 - 6:41 
GeneralRe: Figured it out with some modifications to the C# version: Pinmembercakewalkr715 Apr '11 - 5:45 
I ran into the same issue as the previous poster regarding the sorting property that is actually another class. I tried fully qualifying the property such as below.
 
public class UserProject{
public int ProjectId {get;set;}
public Priorities Priority {get;set;}
}
 
public class Priority{
public int PriorityRank {get;set;}
}
 
I get a javascript error message when I try to sort on UserProject.Priority.PriorityRank that says "Instance property 'UserProject.Priority.PriorityRank' is not defined for type Objects.ListResults.UserProject". Were you ever able to figure out a way around this? Thanks!
GeneralRe: This is a neat concept, but example does not compile. PinmemberAdamNThompson23 Jun '09 - 11:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Mobile
Web01 | 2.6.130523.1 | Last Updated 24 Jun 2009
Article Copyright 2009 by AdamNThompson
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid