compare strings with multiple strings

Question

I am trying to select from multiple string matches.

Condition-

select from CardTagTables whose column CardTagName doesn't have these strings- String1, String2.

List<string> stringArray =new List<string>{ "String1", "String2" };
var query = (from u in db.CardTables
             join v in db.CardTagTables
             on u.CardID equals v.FKCardTagID
             where u.IsApproved == "YES" &&
                   !v.CardTagName.Contains(stringArray.ToString())

I am trying to fetch only records except strings in stringArray.

There are two strings- String1 and String2

nvoigt · Accepted Answer · 2014-03-02 12:22:20Z

1

Replace

v.CardTagName.Contains(stringArray.ToString()

with

v.CardTagName.Any(element => stringArray.Contains(element))

answered Mar 2, 2014 at 12:22

nvoigt

77.7k28 gold badges103 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3163213 Over a year ago

It says me List<string>.Contains(string) has some invalid arguments.

nvoigt Over a year ago

What type is CardTagName?

nvoigt Over a year ago

Wow, I thought CardTagName would again be a list of tags. If that is only a sigle string and you want those that are not contained in your array, why didn't you do it that way: !stringArray.Contains(v.CardTagName)

Selman Genç · Accepted Answer · 2014-03-02 15:00:20Z

1

You just need to change Contains order, instead of this:

!v.CardTagName.Contains(stringArray.ToString())

Try:

!stringArray.Contains(v.CardTagName)

answered Mar 2, 2014 at 15:00

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Comments

Oscar Bralo · Accepted Answer · 2014-03-02 14:57:52Z

0

Try somethign like this:

var result = CardTagTables.Select(x => stringArray.Any(y => x.CardTagName.Contains(y))).ToList();

It´s untested, but I think that is the idea ;)

answered Mar 2, 2014 at 14:57

Oscar Bralo

1,90713 silver badges12 bronze badges

Collectives™ on Stack Overflow

compare strings with multiple strings

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related