What should I do to make The search result return either the input was Upper or lower case?

user_14157386 0
Viewed 66

This Will return only when the user is available at the same case

 public async Task<IActionResult> Index(string UserSearch)
    {
        ViewData["GetUserDDetails"] = UserSearch;

        var UserQuery = from x in _context.Users select x;
        if (!string.IsNullOrEmpty(UserSearch))
            {
            UserQuery = UserQuery.Where(x => x.Username.Contains(UserSearch) || x.Email.Contains(UserSearch));
        }
        return View(await UserQuery.AsNoTracking().ToListAsync());
    }
asp.net-core model-view-controller asp.net c#
2 Answers

Use .ToLower() or .ToUpper() on both the query value and the subject value.

x => x.Username.ToLower().Contains(UserSearch.ToLower()) || ...
user_29362040

Try this:

 public async Task<IActionResult> Index(string UserSearch)
 {
    ViewData["GetUserDDetails"] = UserSearch;
    var UserQuery = from x in _context.Users select x;

    if (!string.IsNullOrEmpty(UserSearch))
    {
        UserQuery = UserQuery.Where(x => x.Username.ToUpper().Contains(UserSearch.ToUpper()) || x.Email.ToUpper().Contains(UserSearch.ToUpper()));
    }
    return View(await UserQuery.AsNoTracking().ToListAsync());
 }
user_179649940
Related