LINQ to Entities does not recognize the method Int32 get_Item(Int32)

Question

I am a newbie about entity framework and linq. My query is like that

var query = (from d in db.MYTABLE
             where d.RELID.Equals(myInts[0])
             select d.ID).Distinct();

List<int?> urunidleri = query.ToList();

When i execute this code, i got the error message "LINQ to Entities does not recognize the method Int32 get_Item(Int32)". How can i solve my problem ?

Thanks...

Answer 1

You need to store your int in a variable, so that EntityFramework isn't trying to pull the whole array into its scope.

var myInt = myInts[0];  var query = (from d in db.MYTABLE              where d.RELID.Equals(myInt)              select d.ID).Distinct();  List<int?> urunidleri = query.ToList(); 

Answer 2

var firstInt = myInts[0]; var query = (from d in db.MYTABLE              where d.RELID.Equals(firstInt)              select d.ID).Distinct();  List<int?> urunidleri = query.ToList();