Like condition in MVC4 using lambda

Question

Is there a way for me to do like condition just like query in MVC using lambda? I currently have:

return repository.GetAll().Where(
            m => string.(m.Name, name, StringComparison.OrdinalIgnoreCase));

So how do I make this into a like condition?

If you are using MS Sql Database with the [Collation](https://msdn.microsoft.com/en-us/library/ms180175.aspx) set to CI (Case Insensitive) you don't need to use the StringComparison enum. — Erik Philips, Mar 13 '15 at 15:04

score 0 · Accepted Answer · edited Mar 13 '15 at 15:18

0

use Contains() or StartsWith() or EndsWith() according to your requirement:

var filtered= data.Where(x=> x.Name.ToLower().Contains(name.ToLower()));

in your code:

return repository.GetAll().Where(
        m => m.Name.ToLower().Contains(name.ToLower()));

edited Mar 13 '15 at 15:18

Patrick Hofman

153,850
22
249
325

answered Mar 13 '15 at 15:03

Ehsan Sajjad

61,834
16
105
160

2

a closing parenthesis is missing – Sim1 Mar 13 '15 at 15:04
just to clarify, this will generate a like condition like this: (x.Name like '%myVal%') and not (x.Name like 'myval') – rdans Mar 13 '15 at 15:24

score 0 · Answer 2 · edited May 23 '17 at 12:05

Usually you would use m.Name.Contains, that isn't possible here since it doesn't support case in-sensitiveness, like you have written down now. (if that is not intentional, use m.Name.Contains(name))

Another option mentioned here is the use of CompareInfo.IndexOf, but I don't know if it works well with EF.

Give this a try:

repository
.GetAll()
.Where
 ( m => CultureInfo.InvariantCulture.CompareInfo
       .IndexOf(m.Name, name, CompareOptions.IgnoreCase) > 0
 )

score 0 · Answer 3 · answered Mar 13 '15 at 15:08

0

The only way I have managed this before is with raw sql syntax e.g.

context.Blogs.SqlQuery("SELECT * FROM SomeTable WHERE SomeTable.Name like {0}", name);

answered Mar 13 '15 at 15:08

rdans

2,179
22
32

Wouldn't you still need `%`? – Patrick Hofman Mar 13 '15 at 15:08
only if he needs that in his like comparison. He didnt say he wanted a "Contains" type comparison – rdans Mar 13 '15 at 15:09

Like condition in MVC4 using lambda

3 Answers3

Linked