LINQ to Entities does not recognize the method 'Int32 Parse(System.String)' method,

Question

I am using Entity Framework, and I have a line of code that convert string field (id)to int and compare with a number

 students = students.Where(s => (Int32.Parse( s.id)>5555));

Whenever I try to run it I receive rhis error. "LINQ to Entities does not recognize the method 'Int32 Parse(System.String)' method, and this method cannot be translated into a store expression."

I have tried seveal different things and nothing is working, so any help would be great.

If your model.id have db type int, why you even need to to parse it to int in linq2entities? I think you should repair your model and not cast at all — Jan 'splite' K.
– Jan 'splite' K., Commented May 9, 2015 at 5:26
possible duplicate of Entity Framework/Linq EXpression converting from string to int — Alex
– Alex, Commented May 9, 2015 at 5:27

Aron · Accepted Answer · 2015-05-09 07:02:14Z

5

Firstly I would highly recommend against converting the column into an int, you lose the indexing on the column. You rather convert the int into a string. However here is how to fix your code.

Firstly sign the Contributor License Agreement.
Then you fork the Entity Framework git repo.
Write a new MethodCallTranslator.CallTranslator which will take Convert.ToInt32(string) and replace it with (int) string.
Register the new MethodCallTranslator.CallTranslator within MethodCallTranslator.
Write unit tests for your test case.
Check in
Create Pull Request
Wait
Download new version of Entity Framework from nuget

edited May 9, 2015 at 7:02

answered May 9, 2015 at 6:13

Aron

15.9k3 gold badges35 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jan 'splite' K. Over a year ago

Great step by step tutorial, +1

Collectives™ on Stack Overflow

LINQ to Entities does not recognize the method 'Int32 Parse(System.String)' method,

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related