LINQ to Entities does not recognize the method 'Boolean Contains(Int32)' method

Question

The below exception flown

LINQ to Entities does not recognize the method 'Boolean Contains(Int32)' method, and this method cannot be translated into a store expression.

while trying to execute the below query

List<int> studentIDs = Common.getFilterStudents();
var query = from a in studentTable
            where studentIDs.Contains(a.StudentID)
            select a;

How can I filter the query using the studentIDs list?

Answer 1

It is not possible to use Contains in your EF version, because support for Contains was added in EF 4. Either upgrade your EF version (then your code will work without any problems), or use something like manual expression building:

var query = context.studentTable.Where(
    BuildContainsExpression<Student, int>(s => s.StudentID, studentIDs));