如何使用动态字符串参数执行OrderBy?

问题描述

我想这样做:

var orderBy = "Nome, Cognome desc";

var timb = time.Timbratures.Include("Anagrafica_Dipendente")
    .Where(p => p.CodDipendente == 1);

if(orderBy != "")
    timb = timb.OrderBy(orderBy);

是否有OrderBy重载可用，可以接受字符串参数?

Is there an OrderBy overload available that accepts a string parameter?

推荐答案

绝对.您可以使用LINQ动态查询库，该库 .在CodePlex上 也有更新的版本.

Absolutely. You can use the LINQ Dynamic Query Library, found on Scott Guthrie's blog. There's also an updated version available on CodePlex.

它允许您通过传入字符串参数来创建OrderBy子句，Where子句以及几乎所有其他内容.它非常适合创建用于排序/过滤网格等的通用代码.

It lets you create OrderBy clauses, Where clauses, and just about everything else by passing in string parameters. It works great for creating generic code for sorting/filtering grids, etc.

var result = data
    .Where(/* ... */)
    .Select(/* ... */)
    .OrderBy("Foo asc");

var query = DbContext.Data
    .Where(/* ... */)
    .Select(/* ... */)
    .OrderBy("Foo ascending");

这篇关于如何使用动态字符串参数执行OrderBy?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！