C# Linq to SQL: How to express “CONVERT([…] AS INT)”

clinqlinq-to-sql

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

CONVERT(INT, table.column)

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

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:

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

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

Best Answer

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