Error: LINQ to Entities does not recognize the method 'Int32 ToInt32

Question

I want to convert string to int in linq query and getting following error

Error: LINQ to Entities does not recognize the method 'Int32 ToInt32

In the DataBase Filed arID is varchar

var AllArea = (from arr in dbcontext.Areas
               join city in dbcontext.Cities on Convert.ToInt32(arr.arID) equals city.cityID
               select new
               {
                   arr.arID,
                   arr.AreaName,
                   city.cityID,
                   city.cityName
               }).ToList();

Would it be possible to change your schema instead? This smells like a design issue which is best fixed by changing the database to use more appropriate types. — Jon Skeet, Jun 02 '15 at 05:58
I would preffer TryParse.Int32.TryParse('inputString', out number); https://msdn.microsoft.com/de-de/library/f02979c7%28v=vs.110%29.aspx — Mirko Sbr, Jun 02 '15 at 06:01

score -1 · Answer 1 · edited Jun 02 '15 at 07:08

-1

Try using this - (int)arr.arID ...

edited Jun 02 '15 at 07:08

Edi G.

2,432
7
24
33

answered Jun 02 '15 at 06:16

AvinashSachdewani

146
1
8

A suggestion to try something is not an answer because it's still a gamble and it doesn't explain anything. It might be a comment. – Gert Arnold Jun 02 '15 at 06:20
okay guys thanks for the help. – AvinashSachdewani Jun 02 '15 at 07:05

Error: LINQ to Entities does not recognize the method 'Int32 ToInt32

1 Answers1