LINQ to Entities does not recognize the method ‘Int32 Parse(System.String)’ method, and this method cannot be translated into a store expression
in Linq to Entity, you should use the methods in your query which is supported by your provider to convert them to expression tree to run on your Data Base side. all providers must support some methods by default called Canonical Functions (Read More Here), and also you can define your user defined function and … Read more