按实体框架动态排序 [英] Dynamic Order By Entity Framework

问题描述

以下查询的顺序由于某种原因不做任何排序。我正在做这个吗？它只做一个选择，根本没有排序。

The following order by query does not do any ordering for some reason. Am I doing this correctly? It only does a select, no ordering is applied at all.

var orders = (from order in db.GridExampleTable    
                      select order);
switch (sortBy)
        {
            default: orders.OrderBy(o => o.UnitPrice);
                break;
            case "CustomerName":
                if (sortDir == "asc")
                 orders.OrderBy(o => o.CustomerName);
                else
                    orders.OrderByDescending(o => o.CustomerName);
                  break;

        }

推荐答案

没有收集您的订单的结果。你需要

you are not collecting the results of your order. you need

orders = orders.OrderBy(o=>o.UnitPrice);

等。

这篇关于按实体框架动态排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！