使用Entity Framework时，如何构建动态排序条件

最新推荐文章于 2025-09-10 21:20:58 发布

原创最新推荐文章于 2025-09-10 21:20:58 发布 · 3.5k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#exception #query #string #null

Entity Framework 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一种基于Lambda表达式的分页查询方法实现，该方法支持指定排序字段及方向，并返回指定范围内的记录列表及总数。

/// <summary> /// 分页查询 /// </summary> /// <param name="query"></param> /// <param name="start"></param> /// <param name="limit"></param> /// <param name="sort">排序字段</param> /// <param name="dir">ASC/DESC</param> /// <param name="count">总纪录数</param> /// <returns></returns> public List<T> PageList(IQueryable<T> query, int start, int limit, string sort, string dir, out int count) { if (string.IsNullOrEmpty(sort)) throw new Exception("使用此方法,必须指定排序字段!"); ParameterExpression param = Expression.Parameter(typeof(T), "it"); Expression body = param; if (Nullable.GetUnderlyingType(body.Type) != null) body = Expression.Property(body, "Value"); PropertyInfo sortProperty = typeof(T).GetProperty(sort, BindingFlags.Public | BindingFlags.Instance | BindingFlags.IgnoreCase); if (sortProperty == null) throw new Exception("对像上不存在" + sortProperty + "的字段"); body = Expression.MakeMemberAccess(body, sortProperty); LambdaExpression keySelectorLambda = Expression.Lambda(body, param); string queryMethod = dir == "DESC" ? "OrderByDescending" : "OrderBy"; query = query.Provider.CreateQuery<T>(Expression.Call(typeof(Queryable), queryMethod, new Type[] { typeof(T), body.Type }, query.Expression, Expression.Quote(keySelectorLambda))); count = query.Count(); if (start >= 0 && limit > 0) query = query.Skip(start).Take(limit); return query.ToList(); }