Unable to create a constant value of type. Only primitive types or enumeration types are supported

Question

I have an entity like the following :

class Serial {
    public int Id { get; set; }
    public string No { get; set; }
}

what I have to get is a list of serials by a list of serial ids, but continuously I get the error :

 Unable to create a constant value of type ProjectName.Models.Serial. Only primitive types or enumeration types are supported.

this is what I've written so far :

List<Serial> serials = _ctx.Serials.Where(s => sList.Any(ss => ss.Id == s.Id)).ToList();

and

List<Serial> serials = _ctx.Serials.Where(s => sList.Select(ss => ss.Id).Contains(s.Id)).ToList();

score 0 · Answer 1 · answered Apr 04 '18 at 06:54

It should be as simple as this

var ids =  List<int> { 324,54,234,645};

Var serialized = _ctx.Serials.Where(s => ids.Contains(s.Id)).ToList();

Determines whether a sequence contains a specified element by using the default equality comparer.

1 Answers1