读书人

[Entity Framework] Orderby有关问题

发布时间: 2012-02-08 19:52:21 作者: rapoo

[Entity Framework] Orderby问题
前端传递过来 排序列的值
如何转为查询语句

C# code
public PagedList<T> GetManyPage(QueryModel query,PageSelect pageSel)    {        Type type = typeof(T);        var key = type.GetProperty(pageSel.OrderByKey);                ParameterExpression param = Expression.Parameter(typeof(T), "c");        MemberExpression paramKey = Expression.Property(param, pageSel.OrderByKey);                //var expression = Expression.Lambda<Func<T, TKey>>(paramKey, param);                if (pageSel.Direction == Direction.asc)        {            //return dbset.Where(query).OrderBy(c => pageSel.OrderByKey).ToPagedList(pageSel.CurrentPage, pageSel.PageSize);            return dbset.Where(query).OrderBy(c => key).ToPagedList(pageSel.CurrentPage, pageSel.PageSize);            //return dbset.Where(query).OrderByDescending(c => key).ToPagedList(pageSel.CurrentPage, pageSel.PageSize);        }        return dbset.Where(query).OrderByDescending(c => pageSel.OrderByKey).ToPagedList(pageSel.CurrentPage, pageSel.PageSize);            }


以上是失败代码 想要的结果是正常返回值

QueryModel

[解决办法]
反射吧。

return dbset.Where(query).OrderBy(c => key.GetValue(c,null)).ToPagedList(pageSel.CurrentPage, pageSel.PageSize);
[解决办法]
yes ...i think dynamic linq is ok.
http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx

读书人网 >.NET

热点推荐