SQL IN Query in LINQ With List

Question

Need help in filtering LINQ select query with another List<string>

Like,

List<string> samplingList;

var Result = from F in db.TableA where F.flag == "A" && F.code in (samplingList)

F.Code.Contains() can accept only single value, How can I pass samplingList to LINQ to filter data. Basically I am looking for achieving SQL code value in ('V1', 'V2') in LINQ.

Possible duplicate of [Linq to Entities - SQL "IN" clause](https://stackoverflow.com/questions/857973/linq-to-entities-sql-in-clause) — CodeNotFound, May 15 '18 at 20:33
You can execute a LINQ join on these two entities (TableA and samplingList). Research that. — Jason P Sallinger, May 15 '18 at 20:36

Salah Akbari · Accepted Answer · 2018-05-15T20:37:28.293

2

What about this:

samplingList.Contains(F.code)

So your complete query should be something like this:

var Result = from F in db.TableA where F.flag == "A" &&
             samplingList.Contains(F.code)
             select F;

edited May 15 '18 at 20:37

answered May 15 '18 at 20:30

Salah Akbari

39,330
10
79
109

This Solved the problem! Thank you. – Pradeep H May 15 '18 at 20:42

SQL IN Query in LINQ With List

1 Answers1