Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Searching if value exists in a list of objects using Linq

Tags:

c#

linq

Say I have a class Customer which has a property FirstName. Then I have a List<Customer>.

Can LINQ be used to find if the list has a customer with Firstname = 'John' in a single statement.. how?

like image 605
Tony_Henrich Avatar asked Jul 01 '09 19:07

Tony_Henrich


9 Answers

LINQ defines an extension method that is perfect for solving this exact problem:

using System.Linq;
...
    bool has = list.Any(cus => cus.FirstName == "John");

make sure you reference System.Core.dll, that's where LINQ lives.

like image 114
Stop Putin Stop War Avatar answered Oct 21 '22 03:10

Stop Putin Stop War


zvolkov's answer is the perfect one to find out if there is such a customer. If you need to use the customer afterwards, you can do:

Customer customer = list.FirstOrDefault(cus => cus.FirstName == "John");
if (customer != null)
{
    // Use customer
}

I know this isn't what you were asking, but I thought I'd pre-empt a follow-on question :) (Of course, this only finds the first such customer... to find all of them, just use a normal where clause.)

like image 20
Jon Skeet Avatar answered Oct 21 '22 04:10

Jon Skeet


One option for the follow on question (how to find a customer who might have any number of first names):

List<string> names = new List<string>{ "John", "Max", "Pete" };
bool has = customers.Any(cus => names.Contains(cus.FirstName));

or to retrieve the customer from csv of similar list

string input = "John,Max,Pete";
List<string> names = input.Split(',').ToList();
customer = customers.FirstOrDefault(cus => names.Contains(cus.FirstName));
like image 34
Mike Sackton Avatar answered Oct 21 '22 04:10

Mike Sackton


Using Linq you have many possibilities, here one without using lambdas:

//assuming list is a List<Customer> or something queryable...
var hasJohn = (from customer in list
         where customer.FirstName == "John"
         select customer).Any();
like image 42
jmservera Avatar answered Oct 21 '22 04:10

jmservera


customerList.Any(x=>x.Firstname == "John")
like image 43
Chris Brandsma Avatar answered Oct 21 '22 04:10

Chris Brandsma


The technique i used before discovering .Any():

var hasJohn = (from customer in list
      where customer.FirstName == "John"
      select customer).FirstOrDefault() != null;
like image 36
Ian Boyd Avatar answered Oct 21 '22 05:10

Ian Boyd


List<Customer> list = ...;
Customer john = list.SingleOrDefault(customer => customer.Firstname == "John");

john will be null if no customer exists with a first name of "John".

like image 29
M4N Avatar answered Oct 21 '22 04:10

M4N


Try this, I hope it helps you.

 if (lstCustumers.Any(cus => cus.Firstname == "John"))
 {
     //TODO CODE
 }
like image 22
Fabio Stratotti Avatar answered Oct 21 '22 05:10

Fabio Stratotti


Another possibility

if (list.Count(customer => customer.Firstname == "John") > 0) {
 //bla
}
like image 28
Krassi Avatar answered Oct 21 '22 05:10

Krassi