C#中的LINQ to SQL:如何前preSS" CONVERT([...] AS INT)QUOT ;?

问题描述:

在MSSQL您可以将字符串转换为这样一个整数:

In MSSQL you can convert a string into an integer like this:

CONVERT(INT, table.column)

有没有C#的前pression的LINQ到SQL将转化呢?

Is there any C# expression that Linq to SQL would translate to this?

在C#中,你可以正常做同样的使用 int.Parse(),但不幸的是,试图用 int.Parse()在一个错误LINQ查询的结果:

In C# you can normally do the same by using int.Parse(), but unfortunately, trying to use int.Parse() in a Linq query results in an error:

方法的Int32解析(System.String)没有支持转换为SQL。

Method 'Int32 Parse(System.String)' has no supported translation to SQL.

有没有C#的前pression的LINQ到SQL会转化为 CONVERT(INT,...)

Is there any C# expression that Linq to SQL would translate to CONVERT(INT, ...)?

C#有 Convert.ToInt32() 应该做你要找的东西。

C# has Convert.ToInt32() which should do what you're looking for.