Orderby not working

asp.net-mvc c# dynamic-linq entity-framework linq

Question

I am sorting on multiple criteria using dynamic sorting, here's my code:

    public ActionResult WebGrid(int page = 1, int rowsPerPage = 10, string sortCol = "OrderID", string sortDir = "ASC", string sortSecCol = "OrderID", string sortSecDir = "ASC")
    {
        List<Orders> res;

        using (var nwd = new NorthwindEntities())
        {
            var _res = nwd.Orders
                .AsQueryable()
                .OrderBy(sortCol + " " + sortDir, sortSecCol + " " + sortSecDir)
                .Skip((page - 1) * rowsPerPage)
                .Take(rowsPerPage)
                .Select(o => new Orders  
                {

What I am trying to do in here is I want the column OrderID be the secondary sort whenever it is not a primary sort, but it didn't work when I actually selected other column as a primary sort.

In order words, when other column is select as primary sort in descending order, OrderID should also be in descending order, I am not sure what did I missed in my code.

The OrderBy method I used is come from here (MSDN).

1
2
9/9/2016 10:40:21 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

The method you are using has the following signature:

public static IQueryable<T> OrderBy<T>(
    this IQueryable<T> source,
    string ordering,
    params object[] values
)

so the sortSecCol + " " + sortSecDir goes to values argument, while the whole ordering is supposed to be provided as comma separated list in the ordering argument.

You can use something like this instead:

var ordering = sortCol + " " + sortDir;
if (sortSecCol != sortCol)
    ordering += ", " + sortSecCol + " " + sortSecDir;
...
   .OrderBy(ordering)
...
4
9/8/2016 10:24:55 PM

Popular Answer

try this:

    if (sortCol == "OrderID" && sortDir == "ASC")
    {
        _res = l.OrderBy(x => x.OrderId).ThenBy(x => x.AnotherField);
    }
    if (sortCol == "OrderID" && sortDir == "DESC")
    {
        _res = l.OrderByDescending(x => x.OrderId).ThenByDescending(x => x.AnotherField);
    }
    if (sortCol == "AnotherField" && sortDir == "ASC")
    {
        _res = l.OrderBy(x => x.AnotherField).ThenBy(x => x.OrderId);
    }
    if (sortCol == "AnotherField" && sortDir == "DESC")
    {
        _res = l.OrderByDescending(x => x.AnotherField).ThenByDescending(x => x.OrderId);
    }

    _res.Skip((page - 1) * rowsPerPage)
            .Take(rowsPerPage)
            .Select(o => new Orders  
            {
burzhuy

Related Questions

Sortable JqGrid with Dynamic LINQ and LINQ to MySQL (DbLinq) - Orderby doesn't work

The ...tickets... variable is ordered, but then you use that as the source for another query which is NOT ordered so it's order is undetermined. You want the orderby on the second LINQ query.
c# dblinq dynamic-linq jqgrid linq-to-mysql
asked by PatrickSteele

Linq to NHibernate and Dynamic LINQ - query caching not working

Ok, I know what is the reason....Dynamic Linq doesn't use Parameter Names in Linq Expressions. E.g. if I want to sort using lambda statemant, I write:...query.OrderBy(item => item.Name) ...Above we see an ...item... lambda parameter name....When I use Dynamic linq:...query.OrderBy("Name") ...in the result Queryable the lambda parameter in OrderBy m...
dynamic-linq linq linq-to-nhibernate nhibernate
asked by cryss

Dynamic Linq query not working as expected - what am I doing wrong?

From your code it looks like you are operating on the var "query" which is an empty enumerable. Remember, what you have called query is the data set, the Where statement is the query on that data set. So the first query is on an empty data set and it looks like the additional queries from the foreach will just refine that empty set....Also, you can...
c# dynamic-linq linq
asked by Thabo

DynamicLinq C# not working in join

The solution to the problem was:...var lista = (from a in db.Usuario.AsQueryable() join b in db.UsuarioAcesso.AsQueryable() on a.UsuarioID equals b.UsuarioID select new { a.UsuarioID, a.Nome, a.Login, a.Email }) .OrderBy(aOrderna + " " + aOrdenaTipo) .Skip(aIniciarNoRegistro) .Take(aQtdeRegistro); ...But d...
c# dynamic-linq join linq select
asked by Tiedt Tech

Dynamic Linq Query not working with DateTime field

Maybe I'm missing something but don't you have to wrap your date in quotes or something to get it to treat it as a date? I'm trying to remember how the Dynamic Linq works but there must be some way of telling the extension methods that your criteria isn't a primitive type?...OBJ_DATE.Date == "2012.01.01" ...UPDATE... - Ah ha I knew that code looked...
asp.net-mvc c# datetime dynamic-linq
asked by Nick Albrecht

How does nesting an OrderBy in a Dynamic Linq query work?

By default DynamicLinq support a little functions for nested query to ...IEnumerable... fields, all it defined in inteface ...IEnumerableSignatures... like ...Where..., ...Any..., ...Count... and etc, but don't have ...Orderby..., ...Select... or ...FirstOrDefault... what you need.... So you can add it to this interface like ...interface IEnumerabl...
c# dynamic-linq linq
asked by Grundy

Dynamic linq query is not working with numeric value

You use parametrized query and pass as parameter string value, so this parameter have type string and you get error with operand types....for solving just pass decimal value, like...dgvLoadTable.DataSource = EntityName .TableName .Where(columnName + " = @0", int.Parse(searchValue) ) .ToList();
c# dynamic-linq winforms
asked by Grundy

nested "Any" in is not working in dynamic linq

If it's of any help to anyone, I figured out the cause. It is an issue in the original source and i have just done a pull request on Github with a fix for it....https://github.com/kahanu/System.Linq.Dynamic/pull/68...This issue will occur with any nested linq method call. Solved by replacing a variable in their parser with a Stack to get the right ...
c# dynamic-linq linq
asked by finite8

Dynamic Linq Querystring not working with mixed operators along with contains

I made a silly mistake there. The code is working fine but I gave wrong index there. Index 3 should be replaced with 2. :P ...enter image description here...The result is attached.
.net c# dynamic-linq linq linq-to-sql
asked by KNIGHT

Dynamic select is not working for Guid name property

When using ...System.Linq.Dynamic.Core..., you have 2 options:...Use ...it...var result = myClasses.Select($"new(it.Guid)"); ...Escape reserved name with a ...@...var result = myClasses.Select($"new(@Guid)");
c# dynamic-linq select
asked by Stef Heyenrath

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow