问题描述
在 MSSQL 中,您可以像这样将字符串转换为整数:
In MSSQL you can convert a string into an integer like this:
CONVERT(INT, table.column)
Linq to SQL 是否有任何 C# 表达式可以转换成这个?
Is there any C# expression that Linq to SQL would translate to this?
在 C# 中,您通常可以使用 int.Parse() 来做同样的事情,但不幸的是,尝试在 Linq 查询中使用 int.Parse() 会导致错误:
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 Parse(System.String)"不支持转换为 SQL.
Method 'Int32 Parse(System.String)' has no supported translation to SQL.
Linq to SQL 是否有任何 C# 表达式可以转换为 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.