Search text contains with QueryOver

Question

I'm trying to do this :

var list = Session.QueryOver<Person>()
    .Where(x => x.LastName.Contains(searchText))
    .List<Person>();

but I get this error : Unrecognised method call: System.String:Boolean Contains(System.String)

Do you have an idea ?

Update :

public class Person
{
    public virtual string FirstName { get; set; }
    public virtual string LastName { get; set; }
}

score 34 · Accepted Answer · edited Mar 16 '15 at 20:36

34

NHibernate does not have direct C# equivalent as mentioned on this link http://nhibernate.info/blog/2009/12/17/queryover-in-nh-3-0.html

Additional Restrictions

Some SQL operators/functions do not have a direct equivalent in C#. (e.g., the SQL where name like '%anna%'). These operators have overloads for QueryOver in the Restrictions class, so you can write:

.Where(Restrictions.On(c => c.Name).IsLike("%anna%"))

There is also an inline syntax to avoid the qualification of the type:

.WhereRestrictionOn(c => c.Name).IsLike("%anna%")

edited Mar 16 '15 at 20:36

hazzik

13,019
9
47
86

answered Jul 22 '12 at 15:47

HatSoft

11,077
3
28
43

Thanks, that's work. But NHProf warn me about performance trouble (with 'like'). I'll may be keep my current code, a Nhibernate query and after a linq query on the result. – TheBoubou Jul 22 '12 at 16:11

score 4 · Answer 2 · edited May 23 '17 at 11:54

4

Looks like QueryOver doesn't support Contains method. You could try with IsLike restriction:

nhibernate queryover LIKE with expression trees
NHibernate 3.0 search with substring
queryover and (x like 'a' or y like 'a')

edited May 23 '17 at 11:54

Community

1
1

answered Jul 22 '12 at 15:52

Miroslav Popovic

12,100
2
35
47

score 2 · Answer 3 · edited Mar 10 '14 at 14:02

2

var data = session.QueryOver<tablename>()    
                  .JoinQueryOver<if another table present>(x => x.Empsals)    
                  .WhereRestrictionOn(x => x.FName).IsLike("a%")        
                  .List<EmployeeDetails>();

edited Mar 10 '14 at 14:02

Ashley Medway

7,151
7
49
71

answered Mar 10 '14 at 13:44

score 1 · Answer 4 · answered Mar 10 '14 at 13:49

1

WhereRestrictionOn(x => x.FName).IsLike("a%") use like this

answered Mar 10 '14 at 13:49

Abhijeet

43
1
10

Search text contains with QueryOver

4 Answers4

Linked