entityMap|blocks|key|cv2fi|text|Version类应该是一个很好的方法。不幸的是，Version.Parse在Linq2Entity上失败了，因此您必须首先从您的sql服务器获取数据，然后对其进行排序。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|bj5rq|var+result+=+input.AsEnumerable<string>().OrderBy(x+=>+Version.Parse(x.Code));|code-block|syntax|javascript|eg2jr^0|O|D|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|M|9|@$A|N|B|O|C|D]]|E|@]|F|$]]|$2|G|4|H|6|I|8|P|9|@]|E|@]|F|$J|K]]|$2|L|4|-4|6|7|8|Q|9|@]|E|@]|F|$]]]]

The Version class should be a good approach for that. Unfortunately <code>Version.Parse</code> fails at Linq2Entity so you have to fetch the data first from your sql-server and sort it afterwards.

<pre><code>var result = input.AsEnumerable&lt;string&gt;().OrderBy(x =&gt; Version.Parse(x.Code));
</code></pre>

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://msdn.microsoft.com/en-us/library/234b841s(v=vs.110%2529.aspx)|blocks|key|agpk7|text|当作为查询(例如LINQ+)执行时，应用正确的排序(OrderBy)是有问题的，因为表达式被直接转换成SQL表达式，而没有这样的ORDER+BY子句。|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|cdb4t|您可以执行没有特定排序的SQL来物化数据(例如，对其运行.ToList()+)，然后使用这个特定的排序覆盖(https://msdn.microsoft.com/en-us/library/234b841s(v=vs.110%2529.aspx))对内存中的数据进行排序。|cpnjo|这就是你的自定义比较器实现可能的样子(从上面的页面复制并更新，按原样留下评论等)：|cq539|public+class+CodeComparer+:+IComparer<MyEntity>
{
++++public+int+Compare(MyEntity+x,+MyEntity+y)
++++{
++++++++if+(x+==+null)
++++++++{
++++++++++++if+(y+==+null)
++++++++++++{
++++++++++++++++//+If+x+is+null+and+y+is+null,+they're
++++++++++++++++//+equal.+
++++++++++++++++return+0;
++++++++++++}
++++++++++++else
++++++++++++{
++++++++++++++++//+If+x+is+null+and+y+is+not+null,+y
++++++++++++++++//+is+greater.+
++++++++++++++++return+-1;
++++++++++++}
++++++++}
++++++++else
++++++++{
++++++++++++//+If+x+is+not+null...
++++++++++++//
++++++++++++if+(y+==+null)
++++++++++++++++//+...and+y+is+null,+x+is+greater.
++++++++++++{
++++++++++++++++return+1;
++++++++++++}
++++++++++++else
++++++++++++{
++++++++++++++++return+ToComparableString(x.Code).CompareTo(ToComparableString(y.Code));

++++++++++++}
++++++++}
++++}

++++private+string+ToComparableString(string+input)
++++{
++++++++var+split+=+input.Split(new+[]+{'.'});
++++++++return+string.Join(".",+split.Select(x+=>+x.PadLeft(5,+'0')));
++++}
}|code-block|syntax|javascript|e9qa9|然后，应用排序：|bbge0|var+query+=+(...your+Query+or+data+source...).ToList();
var+sortedList+=+query.Sort(new+CodeComparer());|aa6tk|它会将类似"1.15.141“的字符串转换为"00001.00015.0141"，使其具有可比性。(你也可以删除点.，也可以将填充长度调整为预期的最大值，例如，如果每个“节点”的最大值为99，则将其设置为2而不是5。|5crka^0|Q|7|1S|8|0|S|9|1I|1V|0|0|0|0|0|0|1L|1|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|12|G|@$H|13|I|14|J|K]|$H|15|I|16|J|K]]|L|@]|6|$]]|$A|M|C|N|2|E|F|17|G|@$H|18|I|19|J|K]]|L|@$H|1A|I|1B|A|1C]]|6|$]]|$A|O|C|P|2|E|F|1D|G|@]|L|@]|6|$]]|$A|Q|C|R|2|S|F|1E|G|@]|L|@]|6|$T|U]]|$A|V|C|W|2|E|F|1F|G|@]|L|@]|6|$]]|$A|X|C|Y|2|S|F|1G|G|@]|L|@]|6|$T|U]]|$A|Z|C|10|2|E|F|1H|G|@$H|1I|I|1J|J|K]]|L|@]|6|$]]|$A|11|C|-4|2|E|F|1K|G|@]|L|@]|6|$]]]]

It's problematic to apply the correct sorting (<code>OrderBy</code>) when executing as a Query (e.g. LINQ to Entities), because the expression is directly converted to a <code>ORDER BY</code> SQL Expression, and there is no such SQL clause.

What you CAN do is execute the SQL without a particular sorting to materialize the data (e.g. run <code>.ToList()</code> on it) and then sort the Data in Memory using <a href="https://msdn.microsoft.com/en-us/library/234b841s(v=vs.110).aspx" rel="nofollow noreferrer">this specific Sort Override</a>.

This is how your custom Comparer implementation could look like (copied from above page and updated, left comments as is etc.):

<pre><code>public class CodeComparer : IComparer&lt;MyEntity&gt;
{
 public int Compare(MyEntity x, MyEntity y)
 {
 if (x == null)
 {
 if (y == null)
 {
 // If x is null and y is null, they're
 // equal. 
 return 0;
 }
 else
 {
 // If x is null and y is not null, y
 // is greater. 
 return -1;
 }
 }
 else
 {
 // If x is not null...
 //
 if (y == null)
 // ...and y is null, x is greater.
 {
 return 1;
 }
 else
 {
 return ToComparableString(x.Code).CompareTo(ToComparableString(y.Code));

 }
 }
 }

 private string ToComparableString(string input)
 {
 var split = input.Split(new [] {'.'});
 return string.Join(".", split.Select(x =&gt; x.PadLeft(5, '0')));
 }
}
</code></pre>

And then, you apply the Sorting:

<pre><code>var query = (...your Query or data source...).ToList();
var sortedList = query.Sort(new CodeComparer());
</code></pre>

It will convert a string like "1.15.141" to "00001.00015.0141", making it comparable. (you could also remove the dot <code>.</code>, also you can adjust the padding length to the expected maximum number, e.g. make it 2 instead of 5 if you have a maximum of 99 per "node".

entityMap|blocks|key|fjfvm|text|如果您的表中有大量数据，那么您就不能真正使用建议的解决方案，这些解决方案需要从服务器提取所有数据，然后在客户端进行排序。要在服务器上做到这一点，并且仍然使用Entity+Framework，您需要创建SQL函数或可计算列并按此进行排序，除非您知道如何仅使用Entity+Framework可转换为SQL的函数将代码转换为可排序的形式。如果您使用的是SQL+Server，则SQL函数示例如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3l573|CREATE+FUNCTION+dbo.DotSeparatedSort(@input+varchar(max))
RETURNS+hierarchyid
AS
BEGIN
++++return+CAST(N'/'+%2B+replace(@input,+'.',+'/')+%2B+N'/'+AS+hierarchyid)
END|code-block|syntax|javascript|8rfce|它会将点分隔的数字转换为hierarchyid类型，该类型具有您需要的排序语义。|offset|length|style|CODE|4kr1h|对计算列也可以这样做(只需将CAST(N'/'+%2B+replace(Code,+'.',+'/')+%2B+N'/'+AS+hierarchyid)作为公式)。|8c6m1|然后你需要将函数导入EF模型(细节取决于你使用的EF版本，是代码优先还是数据库优先)，并按此排序：|e1edg|ctx.Entities.OrderBy(c+=>+ctx.DotSeparatedSort(c.Code))|79dku|它将被翻译成select+*+from+Entities+order+by+dbo.DotSeparatedSort(Code)。在计算列的情况下，显然只需按此进行排序。|tqau|如果你使用计算列-你可以在它上面定义索引，所以如果你有大量的数据-我更喜欢计算列，因为这一点。|e9ova^0|0|0|C|B|0|E|1M|0|0|0|6|1M|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|Y|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|Z|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|10|9|@$J|11|K|12|L|M]]|A|@]|B|$]]|$2|N|4|O|6|7|8|13|9|@$J|14|K|15|L|M]]|A|@]|B|$]]|$2|P|4|Q|6|7|8|16|9|@]|A|@]|B|$]]|$2|R|4|S|6|E|8|17|9|@]|A|@]|B|$F|G]]|$2|T|4|U|6|7|8|18|9|@$J|19|K|1A|L|M]]|A|@]|B|$]]|$2|V|4|W|6|7|8|1B|9|@]|A|@]|B|$]]|$2|X|4|-4|6|7|8|1C|9|@]|A|@]|B|$]]]]

If you have non-trivial amount of data in your table - you cannot really use proposed solutions which require to pull all data from server and then sort on client. To do that on server and still using Entity Framework you need to either create SQL function or computable column and sort by that, unless you can figure out how to convert your code to sortable form using only functions translatable to SQL by Entity Framework. If you are using SQL Server, example of SQL function would be:

<pre><code>CREATE FUNCTION dbo.DotSeparatedSort(@input varchar(max))
RETURNS hierarchyid
AS
BEGIN
 return CAST(N'/' + replace(@input, '.', '/') + N'/' AS hierarchyid)
END
</code></pre>

Which will convert dot separated numbers to <code>hierarchyid</code> type which has sorting semantics you need. 

The same can be done with computed column (just put <code>CAST(N'/' + replace(Code, '.', '/') + N'/' AS hierarchyid)</code> as formula).

Then you need to import function to EF model (details depend on which EF version you use and if that is code-first or database-first) and sort by that:

<pre><code>ctx.Entities.OrderBy(c =&gt; ctx.DotSeparatedSort(c.Code))
</code></pre>

Which will be translated to <code>select * from Entities order by dbo.DotSeparatedSort(Code)</code>. In case of computed column you obviously just sort by that.

If you use computed column - you can define index on it, so if you have really large amount of data - I'd prefer computed column because of that.

entityMap|blocks|key|7jqdt|text|如果你能做一些假设，比如每个节点最多可以有n个字母。您可以使用此代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|cqcm4|.OrderBy(x+=>+String.Concat(+x.Code.Split('.')
+++++++++++++++++++++++++++++++++++.Select(ss+=>+ss.PadLeft(3,+'0')))+)|code-block|syntax|javascript|4nmtb^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|I|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|J|9|@]|A|@]|B|$F|G]]|$2|H|4|-4|6|7|8|K|9|@]|A|@]|B|$]]]]

If you can make some assumption like every node can have max n letter. you can use this code. 

<pre><code>.OrderBy(x =&gt; String.Concat( x.Code.Split('.')
 .Select(ss =&gt; ss.PadLeft(3, '0'))) )
</code></pre>

I have a queryable of entities with a "Code" field against them

<pre><code>1.1.1,
1.1.2,
1.1.3,
1.1.4,
...,
1.1.10,
1.1.11
</code></pre>

Unfortunately, When I do an <code>.OrderBy(x=&gt; x.Code)</code> on the query, it returns in the following order

<pre><code>1.1.1,
1.1.10,
1.1.11,
1.1.2,
1.1.3,
...
</code></pre>

How can I make it that the object list is ordered by the code field, split by the "."s and as an integer between each part?

This is customer data, so I can't just put a "0" in front of the 1 number ones.
Also it is any number of "."s in this Code field.

Let me know if you require further information.

In LINQ to Entities, How can you order like follows?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

 我有一个可查询的实体，上面有一个"Code“字段 1.1.1,1.1.2,1.1.3,1.1.4,...,1.1.10,1.1.11 不幸的是，当我对查询执行.OrderBy(x=> x.Code)时，它按以下顺序返回 1.1.1,1.1.10,1.1.11,1.1.2,1.1.3,... 如何才能使对象列表按代码字...

问在LINQ to Entities中，如何像下面这样排序？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在LINQ to Entities中，如何像下面这样排序？EN