Multiple string values to compare with one. something like attributetocheck.Equals(att1,att2,att3)

Question

I have multiple attributes say att1,att2,att3 which can be separated by any of the separator. I want to have an "OR" condition in the below query to check if the row value in COLUMN1 is equal or not. Since .Equals can only have a string ,Can any one suggest any other way of doing it.

string result = string.Join(",", attributes);
            List<string> query = (from DataRow dr in response.Output.Tables[0].Rows
                                         where dr["COLUMN1"].ToString().Equals(result)
                                         select dr["COLUMN2"].ToString()).ToList<string>();

http://stackoverflow.com/questions/6034503/multiple-string-comparison-with-c-sharp http://stackoverflow.com/questions/18336480/fast-multiple-string-compare — Thomas, Apr 30 '15 at 12:38
those two are both related. the later even uses linq in its answer — Thomas, Apr 30 '15 at 12:39
@Thomas Linq in the link provided kind of hardcodes it in my code..Help appreciated .....Thanks — NewInCoding, Apr 30 '15 at 13:01

score 3 · Answer 1 · answered Apr 30 '15 at 12:40

3

Instead of joining attributes to an string, use it's Contains method

List<string> query = (from DataRow dr in response.Output.Tables[0].Rows                                         
                      where attributes.Contains(dr["COLUMN1"].ToString())
                      select dr["COLUMN2"].ToString()).ToList<string>()

answered Apr 30 '15 at 12:40

Mehrzad Chehraz

5,092
2
17
28

..Thanks a lot for the elaboration .Thanks – NewInCoding Apr 30 '15 at 13:02

Multiple string values to compare with one. something like attributetocheck.Equals(att1,att2,att3)

1 Answers1