Linq query Contains method with where condition with case sensitive less search

Question

I am trying get the data which is contains single word with in the word.Like below query.

List<Models.tbluser> memberslist = new List<Models.tbluser>();
var obct = (from memlist in objcontext.tblusers
           where memlist.logname.Contains(member)
          select new
          {
              userid = memlist.userid,
              logname = memlist.logname,

              decription = memlist.description
           }).ToList();

foreach (var item in obct)
{
    memberslist.Add(new tbluser
        {
            userid = item.userid,
            logname = item.logname,

            description = item.decription
         });
}

return Json(memberslist);

But here my problem is i need to search with out case sensitive.

For example

If i search with 'a' i need to get data like Admin,Administrator,User Data.

But i am not getting all these because i am searching with Contains() method.Please let me know how can i get all value either the search value is case sensitive less also.

You are NOT searching using `Contains()` or at least not in the code you have posted. If you want to do a case insensitive `Contains()` equivalent see this http://stackoverflow.com/questions/444798/case-insensitive-containsstring — Ben Robinson, Nov 26 '14 at 12:45

Eren Ersönmez · Answer 1 · 2014-11-26T14:00:56.927

3

Change your where condition to be:

memlist.logname.ToUpper().Contains(member.ToUpper())

As a side note, you can shorten your query a bit (you don't need to create an intermediary list):

var memberslist =  objcontext.tblusers
    .Where(x => x.logname.ToUpper().Contains(member.ToUpper())
    .AsEnumerable()
    .Select(x => new tbluser
        {
           userid = x.userid,
           logname = x.logname,
           decription = x.description
        })
    .ToList();

return Json(memberslist);

edited Nov 26 '14 at 14:00

answered Nov 26 '14 at 12:46

Eren Ersönmez

38,383
7
71
92

At least for Linq2SQL you cant create table entities inside a db query. `Explicit construction of entity type '...' in query is not allowed.` – Magnus Nov 26 '14 at 13:51
@Magnus good point, added `AsEnumerable()` to workaround that issue. – Eren Ersönmez Nov 26 '14 at 14:02

score 1 · Accepted Answer · answered Nov 26 '14 at 12:46

You can change them to Lower or Upper Case when checking the condition using ToLower() or ToUpper():

var obct = (from memlist in objcontext.tblusers
            where memlist.logname.ToLower().Contains(member.ToLower())
            select new
                 {
                   userid = memlist.userid,
                   logname = memlist.logname,
                   decription = memlist.description

                 }).ToList();

Linq query Contains method with where condition with case sensitive less search

2 Answers2