Search multiple column values with one search string-CodePudding

I have this query where I want to return results if the search string provided yields data from the 'FirstName' and 'LastName' column of my database. They each work individually as I can get results for Firstname = 'john' and LastName = 'doe'. I also want to be able to pass in a search string of 'John doe' and get results. How would I implement this using .net/linq

snippet: var query = _context.Players.Where(p => p.Firstname.Contains(searchString.ToLower().Trim()) || p.Lastname.Contains(searchString.ToLower().Trim()));

CodePudding user response：

use Split function like the following:

var parts = searchString.Split();
snippet: var query = _context.Players.Where(
     p => p.Firstname.Contains(parts[0].ToLower().Trim())
       || p.Lastname.Contains(parts[1].ToLower().Trim()));

Extracted from the official docs:

If the separator parameter is null or contains no characters, white-space characters are assumed to be the delimiters.

CodePudding user response：

Separating the input data is also convenient

  var parts = searchString.Split();
    var partOne = parts[0].ToLower().Trim();
    var partTwo = parts[1].ToLower().Trim()
    
    var query = _context.Players.Where(
         p => p.Firstname.Contains(partOne)
           || p.Lastname.Contains(partTwo));