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
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