Array fo String to Use with IN CLAUSE in LINQ

Question

I would like to use string array in linq query with IN CLAUSE like below

    string[] strArray = {"A", "B", "C", "D"};
    foreach (var item in SomeCollection.Where(x => x.column.Contains(seriesIIType)))
    {

    }

But I am getting below error.

Error 1 The best overloaded method match for 'string.Contains(string)' has some invalid arguments Error 2 Argument 1: cannot convert from 'string[]' to 'string'

Because your question is unclear, and the code is not complete (and is probably incorrect too), then don't be surprised that all the answers are simply *guessing* what you want. — sstan, Aug 19 '16 at 15:39
@sstan, I think my question very much clear as I just wanted to use IN clause with LINQ so no need to explain further about class model. — LifeOfPi, Aug 19 '16 at 15:54

score 3 · Answer 1 · answered Aug 19 '16 at 15:35

3

It seems to me like you want to do this instead:

SomeCollection.Where(x => strArray.Any(y => x.column.Contains(y)));

But I don't know how x.column.Contains works because I don't know what x.column is.

answered Aug 19 '16 at 15:35

rory.ap

34,009
10
83
174

Shyju · Accepted Answer · 2016-08-19T15:36:58.443

2

Call the Contains method on your array.

string[] strArray = {"A", "B", "C", "D"};
SomeCollection.Where(x => strArray.Contains(x.column))

This will return those items which has column property value is either one of those in the array.

Assuming column property is of same type as your array (string)

edited Aug 19 '16 at 15:36

answered Aug 19 '16 at 15:34

Shyju

214,206
104
411
497

1

What if x.column = "ABC"? – Steve Aug 19 '16 at 15:36
Then it is not going to return that item. I don't think that is what the OP wanted. My answer was to fix the compiler error where he was not using the method properly. – Shyju Aug 19 '16 at 15:37
@Steve I don't get your question still :) – Shyju Aug 19 '16 at 15:39
1

@Shyju, x.column is type of string. And yes my compile time error has been fixed. – LifeOfPi Aug 19 '16 at 15:42
I was pointing to the fact that your answer is _An element of Array Contains Column_, while I had the impression that user wanted _a Column Contains an element of Array_ but he has already made the choice between your answer an the one from rory.ap, so question closed. – Steve Aug 19 '16 at 16:13
I see. Thanks for clarifying. – Shyju Aug 19 '16 at 16:14

score 0 · Answer 3 · edited May 23 '17 at 10:28

0

I think it should be the other way around:

string[] seriesIIType = {"OC", "RH", "RC", "OA"};
foreach (var item in SomeCollection.Where(x => seriesIIType.Contains(x.Column)))
        {
        }

For reference: Linq to Entities - SQL "IN" clause

Is it very intuitive, isn't? but that's how it works in Linq world.

edited May 23 '17 at 10:28

Community

1
1

answered Aug 19 '16 at 15:34

Freddy Ayala

49
4

Array fo String to Use with IN CLAUSE in LINQ

3 Answers3