LINQ to check if ID exists in List LINQ to check if ID exists in List sql sql

LINQ to check if ID exists in List


Yes, it is possible.

(from item in yourContext.YourTable where yourList.Contains(item.ID) select item).ToList();


You can do this with Contains its translated into sql IN:

context.SomeTable.Where(r => someListOfId.Contains(r.ID));