LINQ to Entities Does Not Recognize "System.String ToString ()" Method

Question

string[] userIds = userList.Split(','); // is an array of integers IList<User> users = (from user in this.repository.Users where userIds.Contains(user.Id.ToString()) select user).ToList(); 

the above query gives

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

What can I do?

Answer 1

Avoid calling ToString . You want something like this:

 userIds.Contains(user.Id) 

To do this, the userIds list must be a collection of the type that user.Id has. If you need integers, use int.Parse to convert strings to integers:

 int[] userIds = userList.Split(',').Select(s => int.Parse(s)).ToArray(); 

Answer 2

use may use something like this,

 where userIds.Contains(SqlFunctions.StringConvert((double)user.Id)) 

instead of where userIds.Contains(user.Id.ToString())

it should work