How to transfer list as a parameter to query in Entity Framework?`

Question

Please help solve my problem.

I want get all strings with required id. I have a list with id.

Example = [1,2,3,4,5]

Query:

db.Sites.Where(c => c.Id == /*{get list this}*/)
        .Select(c => c.Name)
        .FirstOrDefault()

Thanks

Answer 1

Use Contains extension method:

var list=new List<int>{1,2,3,4,5};
var query= db.Sites.Where(c => list.Contains( c.Id)).Select(c => c.Name);

Answer 2

Try

db.Sites.Where(c => list.Contains(c.Id)).Select(c => c.Name).ToArray();

This should return all the names as an array with matching Ids in the list.