LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression

Question

I'm using the following code :

using(var sd=new dataEntities())
{
var listofdata=sd.users.where(d=>d.id.ToString().Contain("2"));// id as int
// error : LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.
}

I looked at the site but did not find answer

Answer 1

You need to use the SQL Function to translate the ToString method.

SqlFunctions.StringConvert((double)id)

Answered Here: Problem with converting int to string in Linq to entities