LINQ OrderBy: best search results at top of results list

Posted by p.campbell on Stack Overflow See other posts from Stack Overflow or by p.campbell
Published on 2010-05-19T17:57:31Z Indexed on 2010/05/19 18:00 UTC
Read the original article Hit count: 471

Filed under:
|
|

Consider the need to search a list of Customer by both first and last names. The desire is to have the results list sorted by the Customer with the most matches in the search terms.

FirstName      LastName
----------     ---------
Foo            Laurie
Bar            Jackson
Jackson        Bro
Laurie         Foo
Jackson        Laurie
string[] searchTerms = new string[] {"Jackson", "Laurie"};

//want to find those customers with first, last or BOTH names in the searchTerms
var matchingCusts = Customers
                       .Where(m => searchTerms.Contains(m.FirstName)
                               ||  searchTerms.Contains(m.LastName))
                       .ToList();

/* Want to sort for those results with BOTH FirstName and LastName 
   matching in the search terms. Those that match on both First and Last
   should  be at the top of the results, the rest who match on 
   one property should be below.
*/

 return matchingCusts.OrderBy(m=>m); 

Desired Sort:

Jackson        Laurie  (matches on both properties)
Foo            Laurie
Bar            Jackson
Jackson        Bro
Laurie         Foo

How can I achieve this desired functionality with LINQ and OrderBy / OrderByDescending?

© Stack Overflow or respective owner

Related posts about LINQ

Related posts about sorting