Linq to Entities - SQL “IN” clause for integer column

Question

Select * From Employee where Id in (1, 2, 5, 7)

Now how can I write this in LINQ query using from where select

var ids = new List<int>() {1, 2, 5, 7}    
from employees in _EmployeeRepository.Table
where employees.id *in list*
select employess

In case of string contains will do. How to achieve for integer column. I know I am missing very basic thing.

Why would `Contains` not work for integer columns? – Nov 09 '17 at 18:43 — , Nov 09 '17 at 18:43
use ids.Contains() in where condition. – Priyank Nov 09 '17 at 18:44 — Priyank, Nov 09 '17 at 18:44

score 6 · Answer 1 · answered Nov 09 '17 at 18:58

6

var ids = new List<int>() {1, 2, 5, 7}    
var result = from employee in _EmployeeRepository.Table
where ids.Contains(employee.id)
select employee;

answered Nov 09 '17 at 18:58

Dido

1 Answers1