Access each element in a list inside a where clause

Question

I have a customer List and a string List where each string is like "blah;huhu";

I want to get all customers whose name is in the last part of the splitted "blah;huhu"

like c.Name == "huhu".

Thats my pseudo code:

String ID = 1000;

var query = customerListWithIdAndName.Where(
    c => c.Name == stringListWith2SemicolonSeparatedStrings.Split().Last()
);

What would be the correct code that I can make a comparison on EACH splitted value?

UPDATE:

I want for every returned customer to assign a value: String ID = 1000; Thus every customer returned must have the id 1000.

you want *I want to get all customers whose name is in the last part of the splitted "blah;huhu"* and *What would be the correct code that I can make a comparison on EACH splitted value*? that's confused — cuongle, Oct 25 '12 at 10:21

Sandor Drieënhuizen · Accepted Answer · 2012-10-25T10:39:00.620

1

Now that I get what you want, this should do it:

var query = customerListWithIdAndName.Where(c =>
   stringListWith2SemicolonSeparatedStrings.Any(
       p => p.Split().Last() == c.Name));

edited Oct 25 '12 at 10:39

answered Oct 25 '12 at 10:17

he wants to compare name with the last splitted value i.e last string after last ; – Pranay Rana Oct 25 '12 at 10:19
I mean what wants to achieve by 'What would be the correct code that I can make a comparison on EACH splitted value?' – Sandor Drieënhuizen Oct 25 '12 at 10:20
Op : I want to get all customers whose name is in the last part of the splitted "blah;huhu" – Pranay Rana Oct 25 '12 at 10:22
Yeah, but that's what the original code already does. In that case, the final question doesn't make sense. – Sandor Drieënhuizen Oct 25 '12 at 10:24
@Sandor sorry, the stringListWith2SemicolonSeparatedStrings is a String Array not List. Your code does not work. Split on a stringList cant work. – Elisabeth Oct 25 '12 at 10:27
@Sandor ok that works fine there is still one minor thing which I updated in my question and I hope it does not make the first solution obsolete ;-). See my init question. – Elisabeth Oct 25 '12 at 11:01
ok this helped me: http://stackoverflow.com/questions/398871/update-all-objects-in-a-collection-using-linq – Elisabeth Oct 25 '12 at 11:15

1 Answers1