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

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

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

DataBase Filed arID contains 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();

      

+3


source to share


1 answer


Try using this - (int)arr.arID

...



0


source







All Articles