Using LINQ, how can I filter a collection on partial string property?

Question

I have a collection of Car objects,

IEnumerable<Car>

And I want to return a filtered collection of car objects, based on a partial string match (it doesn't have to be startswith) where the Car.Name property has certain text in it.

Is this possible using LINQ?

Instead of string.Contains, you could use IndexOf if you want a case-insensitive search, so you can pass a StringComparison value. See http://stackoverflow.com/questions/444798/case-insensitive-containsstring — Peter, Feb 21 '11 at 12:13

score 6 · Accepted Answer · answered Feb 21 '11 at 12:10

6

from c in cars
where c.Name.Contains("certain text")
select c

or

cars.Where(c => c.Name.Contains("certain text"))

answered Feb 21 '11 at 12:10

Stilgar

22,354
14
64
101

score 1 · Answer 2 · answered Feb 21 '11 at 12:11

1

IEnumerable<Car> cars = ...
var filteredCars = cars.Where(car => car.Name.Contains("your text"));

answered Feb 21 '11 at 12:11

Albin Sunnanbo

46,430
8
69
108

score 1 · Answer 3 · answered Feb 21 '11 at 12:11

1

You can use Contains:

var cars = new List<Car>(); //Or whatever makes sense.

var filteredCars = cars.Where(c => c.Name.Contains("searchstring"));

answered Feb 21 '11 at 12:11

Klaus Byskov Pedersen

117,245
29
183
222

Andy Holt · Answer 4 · 2011-02-21T13:28:50.547

0

This may do what you want:

var filteredCars = cars.Where(car => car.Name.Contains("Fiesta"));

You can increase the complexity of the predicate as you wish.

edited Feb 21 '11 at 13:28

answered Feb 21 '11 at 12:11

Andy Holt

572
2
9

Hehe, yes indeed. Without Intelisense I wasn't sure if Contains existed, so I played it safe. – Andy Holt Feb 21 '11 at 12:17
Also how do you know you should .ToArray() the collection? – Stilgar Feb 21 '11 at 12:21
sounds like its more correct after all(with a little tweak) :) http://stackoverflow.com/questions/444798/case-insensitive-containsstring/444818#444818 – naveen Feb 21 '11 at 12:21
@stilgar: i meant the answer not your comment. your point is very valid :) – naveen Feb 21 '11 at 12:27
The ToArray() is on there for no particular reason. I'll remove it to make the example more concise. – Andy Holt Feb 21 '11 at 13:28

Using LINQ, how can I filter a collection on partial string property?

4 Answers4