blocks|key|1155274|text|MyList.OrderBy(x+=>+x.StartDate).ThenByDescending(x+=>+x.EndDate);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1155275|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>MyList.OrderBy(x =&gt; x.StartDate).ThenByDescending(x =&gt; x.EndDate);
</code></pre>

blocks|key|1370468|text|使用ThenByDescending|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1370469|var+hold+=+MyList.OrderBy(x+=>+x.StartDate)
+++++++++++++++++.ThenByDescending(x+=>+x.EndDate)
+++++++++++++++++.ToList();|code-block|syntax|javascript|1370470|您还可以使用查询语法，并说：|1370471|var+hold+=+(from+x+in+MyList
+++++++++++orderby+x.StartDate,+x.EndDate+descending
+++++++++++select+x).ToList();|1370472|ThenByDescending是OrderBy返回的IOrderedEnumerable上的一个扩展方法。另请参阅相关方法ThenBy。|1370473|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/bb534736.aspx|1|http://msdn.microsoft.com/en-us/library/bb534966.aspx|2|http://msdn.microsoft.com/en-us/library/bb534852(VS.95).aspx|3|http://msdn.microsoft.com/en-us/library/bb534743.aspx^0|2|G|2|G|0|0|0|0|0|0|G|H|7|R|I|1Q|6|H|7|1|R|I|2|1Q|6|3|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@$9|17|A|18|1|19]]|E|$]]|$1|F|3|G|5|H|7|1A|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|1B|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|1C|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|1D|8|@$9|1E|A|1F|B|C]|$9|1G|A|1H|B|C]|$9|1I|A|1J|B|C]|$9|1K|A|1L|B|C]]|D|@$9|1M|A|1N|1|1O]|$9|1P|A|1Q|1|1R]|$9|1S|A|1T|1|1U]]|E|$]]|$1|Q|3|-4|5|6|7|1V|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]|Y|$5|T|U|V|E|$W|Z]]|10|$5|T|U|V|E|$W|11]]|12|$5|T|U|V|E|$W|13]]]]

Use <a href="http://msdn.microsoft.com/en-us/library/bb534736.aspx" rel="noreferrer"><code>ThenByDescending</code></a>:

<pre><code>var hold = MyList.OrderBy(x =&gt; x.StartDate)
 .ThenByDescending(x =&gt; x.EndDate)
 .ToList();
</code></pre>

You can also use query syntax and say:

<pre><code>var hold = (from x in MyList
 orderby x.StartDate, x.EndDate descending
 select x).ToList();
</code></pre>

<code>ThenByDescending</code> is an extension method on <a href="http://msdn.microsoft.com/en-us/library/bb534852(VS.95).aspx" rel="noreferrer"><code>IOrderedEnumerable</code></a> which is what is returned by <a href="http://msdn.microsoft.com/en-us/library/bb534966.aspx" rel="noreferrer"><code>OrderBy</code></a>. See also the related method <a href="http://msdn.microsoft.com/en-us/library/bb534743.aspx" rel="noreferrer"><code>ThenBy</code></a>.

blocks|key|1370499|text|VB.NET|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1370500|+MyList.OrderBy(Function(f)+f.StartDate).ThenByDescending(Function(f)+f.EndDate)|code-block|syntax|javascript|1370501|或|1370502|++From+l+In+MyList+Order+By+l.StartDate+Ascending,+l.EndDate+Descending|1370503|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

VB.NET

<pre><code> MyList.OrderBy(Function(f) f.StartDate).ThenByDescending(Function(f) f.EndDate)
</code></pre>

OR

<pre><code> From l In MyList Order By l.StartDate Ascending, l.EndDate Descending
</code></pre>

blocks|key|1370544|text|MyList.OrderBy(x+=>+x.StartDate).ThenByDescending(x+=>+x.EndDate);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1370545|请注意，您也可以在OrderBy中使用Descending关键字(如果需要)。所以另一个可能的答案是：|unstyled|1370546|MyList.OrderByDescending(x+=>+x.StartDate).ThenByDescending(x+=>+x.EndDate);|1370547|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>MyList.OrderBy(x =&gt; x.StartDate).ThenByDescending(x =&gt; x.EndDate);
</code></pre>

Note that you can use as well the Descending keyword in the OrderBy (in case you need). So another possible answer is:

<pre><code>MyList.OrderByDescending(x =&gt; x.StartDate).ThenByDescending(x =&gt; x.EndDate);
</code></pre>

blocks|key|1155502|text|如果您有两个或更多字段要订购，请尝试以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1155503|var+soterdList+=+initialList.OrderBy(x+=>+x.Priority).
++++++++++++++++++++++++++++++++++++ThenBy(x+=>+x.ArrivalDate).
++++++++++++++++++++++++++++++++++++ThenBy(x+=>+x.ShipDate);|code-block|syntax|javascript|1155504|您可以使用类"ThenBy“添加其他字段|1155505|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you have two or more field to order try this:

<pre><code>var soterdList = initialList.OrderBy(x =&gt; x.Priority).
 ThenBy(x =&gt; x.ArrivalDate).
 ThenBy(x =&gt; x.ShipDate);
</code></pre>

You can add other fields with clasole "ThenBy"

Say I have these values in a database table

<pre><code>id = 1
StartDate = 1/3/2010
EndDate = 1/3/2010

id = 2
StartDate = 1/3/2010
EndDate = 1/9/2010
</code></pre>

Now I have so far this orderby for my linq

<pre><code>var hold = MyList.OrderBy(x =&gt; x.StartDate).ToList();
</code></pre>

I want to order it however also using the end date.

Like so the order I would want this in as

<pre><code>id 2
id 1
</code></pre>

So <code>endDates</code> that are greater go first. I am not sure if I need to change this to use some compare function or something.

How to use orderby with 2 fields in linq?

数据库

假设我在一个数据库表中有这些值id = 1StartDate = 1/3/2010EndDate =  1/3/2010id = 2StartDate = 1/3/2010EndDate = 1/9/2010到目前为止，我的linq已经有了这个orderby。var hold = MyList.OrderBy(x =>...

问如何在linq中使用带2个字段的orderby？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在linq中使用带2个字段的orderby？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在linq中使用带2个字段的orderby？
EN