Syntax for using OrderBy in Linq : The Official Microsoft ASP.NET Forums

Reply

Syntax for using OrderBy in Linq

Jun 02, 2010 08:37 PM|LINK

Hello

I would want to use a Variable column Name when I do OrderBy

accordionSlides.OrderBy(m => m.CustomerItemNumber)

please could somebody help with syntax.

I tried accordionSlides.OrderBy(m => ColumnName) it did not work?

Below code works. But I have a variable for ColumnName. It could be m.CustomerItemNumber or m.ItemNumber etc..

Please help with syntax.

public class Company
    {
        public string ItemGroupDesc { get; set; }
        public int CustomerItemNumber { get; set; }
        public int ItemNumber { get; set; }
        public double Quantity { get; set; }


    }

 MyAccordion.DataSource = accordionSlides.OrderBy(m => m.CustomerItemNumber)
            .GroupBy(c => c.IM_ItemGroupDesc, c => new { CustomerItemNumber = c.CustomerItemNumber, ItemNumber = c.ItemNumber, Quantity = c.Quantity },
            (k, enumerable) => new { Key = k, Values = enumerable });
        MyAccordion.DataBind();

Thanks,

urpalshu

Moved by Mikesdotnetting on Jun 02, 2010 08:51 PM

Reply

Re: Syntax for using OrderBy in Linq

Jun 02, 2010 09:00 PM|LINK

http://social.msdn.microsoft.com/Forums/en/adodotnetentityframework/thread/4b2da6af-0d2b-4cc9-909d-ed38a237cef1

Mark the post as answer if it was helpful to you. This solution might be useful for others too.

Edited by smithspd on Jun 02, 2010 09:00 PM

Reply

Re: Syntax for using OrderBy in Linq

Jun 02, 2010 09:00 PM|LINK

use an extension class, examples:

http://blogs.msdn.com/b/swiss_dpe_team/archive/2008/06/05/composable-linq-to-sql-query-with-dynamic-orderby.aspx

you'd be able to use it like:

query = query.OrderBy("variableColName", false);

Regards,
Peter

Reply

Re: Syntax for using OrderBy in Linq

Jun 03, 2010 02:35 PM|LINK

Thank you PeteNet

Somehow I am unable to use it correctly. I added the below class to my page.

public static class DynamicOrderBy
{


    public static IQueryable<TEntity> OrderBy<TEntity>(this IQueryable<TEntity> source, string orderByProperty,
                  bool desc) where TEntity : class
    {


        string command = desc ? "OrderByDescending" : "OrderBy";


        var type = typeof(TEntity);


        var property = type.GetProperty(orderByProperty);


        var parameter = Expression.Parameter(type, "p");


        var propertyAccess = Expression.MakeMemberAccess(parameter, property);


        var orderByExpression = Expression.Lambda(propertyAccess, parameter);


        var resultExpression = Expression.Call(typeof(Queryable), command, new Type[] { type, property.PropertyType },


                               source.Expression, Expression.Quote(orderByExpression));


        return source.Provider.CreateQuery<TEntity>(resultExpression);


    }


}


MyAccordion.DataSource = accordionSlides.OrderBy(ColumnName,false)
.GroupBy(c => c.IM_ItemGroupDesc, c => 
(k, enumerable) => 
MyAccordion.DataBind();




 
new { CustomerItemNumber = c.CustomerItemNumber, ItemNumber = c.ItemNumber, Quantity = c.Quantity },new { Key = k, Values = enumerable });

Thanks

urpalshu

Edited by urpalshu on Jun 03, 2010 02:36 PM
Edited by urpalshu on Jun 03, 2010 02:37 PM

Reply

Re: Syntax for using OrderBy in Linq

Jun 03, 2010 02:50 PM|LINK

you may want to check the value in the Session variable - that you're using for columnname.

this works for me:

string SortColumnName = "EmployeeID";
            NorthWindOrdersDataContext dc = new NorthWindOrdersDataContext();
            var query = from o in dc.Orders
                        select new
                        {
                            EmployeeID = o.EmployeeID,
                            CustomerID = o.CustomerID
                        };


            query = query.OrderBy(SortColumnName, true);


            GridView2.DataSource = query;
            GridView2.DataBind();

* to confirm: the static class should be a separate physical file

EDIT: also, try to sort on the result; use a variable for the results .

Regards,
Peter

Edited by PeteNet on Jun 03, 2010 02:52 PM

Reply

Re: Syntax for using OrderBy in Linq

Jun 03, 2010 07:15 PM|LINK

Thanks, am I missing some using directive.

How would I use this

DynamicOrderBy class.

Also it accepts 3 paraments? But yours does not.

Thanks

urpalshu

Reply

Re: Syntax for using OrderBy in Linq

Jun 03, 2010 07:25 PM|LINK

here's the version I'm using:

using System;
using System.Linq;


using System.Linq.Expressions;


    public static class DynamicSortExtension
    {


        public static IQueryable<TEntity> OrderBy<TEntity>(this IQueryable<TEntity> source, string orderByProperty,
                      bool desc) where TEntity : class
        {


            string command = desc ? "OrderByDescending" : "OrderBy";


            var type = typeof(TEntity);


            var property = type.GetProperty(orderByProperty);


            var parameter = Expression.Parameter(type, "p");


            var propertyAccess = Expression.MakeMemberAccess(parameter, property);


            var orderByExpression = Expression.Lambda(propertyAccess, parameter);


            var resultExpression = Expression.Call(typeof(Queryable), command, new Type[] { type, property.PropertyType },


                                   source.Expression, Expression.Quote(orderByExpression));


            return source.Provider.CreateQuery<TEntity>(resultExpression);


        }
    }

Regards,
Peter

Marked as answer by Wencui Qian - MSFT on Jun 10, 2010 07:51 AM

Reply

Re: Syntax for using OrderBy in Linq

Jun 04, 2010 04:39 PM|LINK

Thanks alot. How would I use this Static Class/ I have it in a seperate file.

And my Orderby is not accepting two parameters.

I think my query is of type IEnumerable. does that matter?

I get this error

Error 38 Instance argument: cannot convert from 'System.Linq.IOrderedEnumerable<AnonymousType#1>' to 'System.Linq.IQueryable'

Error 39 'System.Linq.IOrderedEnumerable<AnonymousType#1>' does not contain a definition for 'OrderBy' and the best extension method overload 'System.Linq.Dynamic.DynamicQueryable.OrderBy(System.Linq.IQueryable, string, params object[])' has some invalid arguments

Company[] accordionSlides = new Company[pTable.Rows.Count];

var query = accordionSlides
           .GroupBy(c => c.IM_ItemGroupDesc, c => new { CustomerItemNumber = c.CustomerItemNumber, ItemNumber = c.ItemNumber, Quantity = c.Quantity },
           (k, enumerable) => new { Key = k, Values = enumerable });
   query = query.OrderBy(ColumnName,false);

Thanks,

urpalshu

Edited by urpalshu on Jun 04, 2010 09:19 PM
Edited by urpalshu on Jun 04, 2010 09:27 PM
Edited by urpalshu on Jun 04, 2010 09:29 PM

Reply

PeteNet

All-Star

81342 Points

11398 Posts

Re: Syntax for using OrderBy in Linq

Jun 07, 2010 08:28 AM|LINK

you could use the AsQueryable() method on IEnumerable (also on generic IEnumerable<T>) to convert to IQueryable

Regards,
Peter

Reply

vikasrulez

Participant

776 Points

183 Posts

Re: Syntax for using OrderBy in Linq

Jun 07, 2010 10:31 AM|LINK

urpalshu

Hello

I would want to use a Variable column Name when I do OrderBy

accordionSlides.OrderBy(m => m.CustomerItemNumber)

please could somebody help with syntax.

I tried accordionSlides.OrderBy(m => ColumnName) it did not work?

Below code works. But I have a variable for ColumnName. It could be m.CustomerItemNumber or m.ItemNumber etc..

Please help with syntax.
<div class="dp-highlighter"><div class="bar"><div class="tools">view plaincopy to clipboardprint?
</div></div>

public class Company
    {
        public string ItemGroupDesc { get; set; }
        public int CustomerItemNumber { get; set; }
        public int ItemNumber { get; set; }
        public double Quantity { get; set; }

    }
</div>
public class Company
    {
        public string ItemGroupDesc { get; set; }
        public int CustomerItemNumber { get; set; }
        public int ItemNumber { get; set; }
        public double Quantity { get; set; }


    }
<div class="dp-highlighter"><div class="bar"><div class="tools">view plaincopy to clipboardprint?
</div></div>
string ColumnName = <font size="2">Session[</font><font color="#a31515" size="2">"COL"</font><font size="2">].ToString();</font>
</div>
 MyAccordion.DataSource = accordionSlides.OrderBy(m => m.CustomerItemNumber)
            .GroupBy(c => c.IM_ItemGroupDesc, c => new { CustomerItemNumber = c.CustomerItemNumber, ItemNumber = c.ItemNumber, Quantity = c.Quantity },
            (k, enumerable) => new { Key = k, Values = enumerable });
        MyAccordion.DataBind();
Thanks,

MyAccordion.DataSource = accordionSlides.GroupBy(c => c.IM_ItemGroupDesc, c => new { CustomerItemNumber = c.CustomerItemNumber, ItemNumber = c.ItemNumber, Quantity = c.Quantity },
(k, enumerable) => new { Key = k, Values = enumerable }).OrderBy(m => m.CustomerItemNumber);

MyAccordion.DataBind();

Vikas Rana vikasrana.com

Marked as answer by Wencui Qian - MSFT on Jun 10, 2010 07:52 AM

Syntax for using OrderBy in Linq RSS

10 replies

urpalshu

Syntax for using OrderBy in Linq

smithspd

Re: Syntax for using OrderBy in Linq

PeteNet

Re: Syntax for using OrderBy in Linq

urpalshu

Re: Syntax for using OrderBy in Linq

PeteNet

Re: Syntax for using OrderBy in Linq

urpalshu

Re: Syntax for using OrderBy in Linq

PeteNet

Re: Syntax for using OrderBy in Linq

urpalshu

Re: Syntax for using OrderBy in Linq

PeteNet

Re: Syntax for using OrderBy in Linq

vikasrulez

Re: Syntax for using OrderBy in Linq

urpalshu

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft