问题描述
我正在为我的公司编写一个应用程序，目前正在研究搜索功能.当用户搜索一个项目时，我想显示最高版本(存储在数据库中).
I am writing an app for my company and am currently working on the search functionality. When a user searches for an item, I want to display the highest version (which is stored in a database).
问题是，版本存储为字符串而不是整数，当我对结果执行 OrderBy(q=>q.Version) 时，它们会像
The problem is, the version is stored as a string instead of int, and when I do an OrderBy(q=>q.Version) on the results, they are returned like
1
10
11
2
3
...
显然 2 在 10 之前.
Obviously 2 comes before 10.
有没有办法让我将版本转换为整数，或者是否有一个简单的 IComparer?到目前为止，我找不到任何实质性的东西.
Is there a way for me to cast the version as an integer or is there a simple IComparer out there? I couldn't find anything substantial thus far.
我尝试这样做:
var items = (from r in results
select r).OrderBy(q => Int32.Parse(q.Version));
这可以编译但不起作用.
This compiles but doesn't work.
推荐答案
LinqToSql 转换器不支持 Int32.Parse.支持 Convert.ToInt32.
Int32.Parse is not supported by the LinqToSql translator. Convert.ToInt32 is supported.
http://msdn.microsoft.com/en-us/library/sf1aw27b.aspx
http://msdn.microsoft.com/en-us/library/bb882655.aspx
这篇关于Orderby() 没有正确排序数字 c#的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！