In clause in Linq to SQL

Question

I have simple SQL query as:

select * from EH_PP_DmainComps
where domainCode in (1,2)

I want to make same query in LINQ.

I made it as:

from a in context.EH_PP_DmainComps
                where a.domainCode.ToString().Contains(id)
                select new Entity.correlations(a)

Note: id in a.domainCode.ToString().Contains(id) has value (1,2) which is to be used within In Clause.

But its not working.

How can i form this simple query in LINQ??

@RandRandom id is simple string containing "1,2,3" which i want to check with a.domainCode — C Sharper, Jun 10 '14 at 07:19
Than it's still id.Contains(), a larger string/array contains a smaller fragment. Contains doesn't say a small fragment is within larger. It's the other way around. — Rand Random, Jun 10 '14 at 07:22

score 2 · Accepted Answer · answered Jun 10 '14 at 07:20

2

I believe you mean:

from a in context.EH_PP_DmainComps
where id.Contains(a.domainCode.ToString())
select new Entity.correlations(a)

answered Jun 10 '14 at 07:20

Dimitar Dimitrov

14,868
8
51
79

Franck Ngako · Answer 2 · 2014-06-10T07:28:30.350

0

you should follow the following steps

1- declare your list of id - var idList = new List<int>(){1,2} 2- use your linq query like this from a in context.EH_PP_DmainComps where idList.Contains(a.domainCode) select new correlations(a)

edited Jun 10 '14 at 07:28

answered Jun 10 '14 at 07:21

Franck Ngako

163
6

In clause in Linq to SQL

2 Answers2