Dynamic Func<IQueryable<TEntity>, IOrderedQueryable<TEntity>> Expression 解析成SQL
0
悬赏园豆：100
[待解决问题]
例如：
Func<IQueryable<Customers>, IOrderedQueryable<Customers>> orderBy = o => o.OrderBy(c => c.CustomerId).OrderByDescending(c => c.Level);
解析成
string sql = "order by CustomerId, Level desc";
所有回答(2)
1
用OrderBy..ThenBy：
.OrderByDescending(c => c.CustomerId)
.ThenByDescending(c => c.Level)
0
可以把所以的条件链接起来，应该也行
public static Expression<Func<T, bool>> And<T>(this Expression<Func<T, bool>> exprLeft,
Expression<Func<T, bool>> exprRight)
{
var invokedExpr = Expression.Invoke(exprRight, exprLeft.Parameters);
return Expression.Lambda<Func<T, bool>>(Expression.AndAlso(exprLeft.Body, invokedExpr), exprLeft.Parameters);
}
