sql IN clause in LINQ

Question

I'm trying to get results similar to SQL IN clause in terms of LINQ with the help of Contains()

I'm doing the following:

listData.Where(pr => pr.CD.Contains(cd)).Select(pr => pr.dept_cd).Distinct()

This works if cd is only one value, but not working when cd is a comma-separated string.

How can I achieve SELECT * FROM TABLE WHERE COLUMN IN(VALUE1,VALUE2...) in case of LINQ?

Do you mean something like `cd.Split(',').Contains(pr.CD)` (although you may want to split into an array on a previous line instead of as part of the Linq expression)? — Joachim Isaksson, Feb 04 '14 at 05:44
Please check below link [IN clause with LINQ][1] [1]: http://stackoverflow.com/questions/959752/where-in-clause-in-linq — Lajja Thaker, Feb 04 '14 at 05:46

Usman · Answer 1 · 2014-02-04T06:00:43.673

0

use it like as follow

var selected = from u in users
               where new[] { "IT", "Admin", "HR" }.Contains(u.dept_cd)
               select u;

or if you have List of string then you should use it as

List<string> dept= new List<string>(){"HR", "IT"};

var selected = from u in users
               where dept.Contains(u.dept_cd)
               select u;

edited Feb 04 '14 at 06:00

answered Feb 04 '14 at 05:45

Usman

3,200
3
28
47

score 0 · Accepted Answer · edited Feb 04 '14 at 06:09

0

It should be reverse. Like below :

listData.Where(pr => cd.Contains(pr.CD).Select(pr => pr.dept_cd)).Distinct();

Not sure of syntax. But this is the approach. Here, cd is the comma separated string or a string array

edited Feb 04 '14 at 06:09

har07

88,338
12
84
137

answered Feb 04 '14 at 05:46

Anil Soman

2,443
7
40
64

sql IN clause in LINQ

2 Answers2