Queryover and (x like 'a' or y like 'a')

Question

Hi Is there an elegant way to combine like and or when I use the Query Query API? for 'like' there is something like:

query.WhereRestrictionOn(x=>x.Code).IsLike(codePart) 

for 'or' I can do something like:

 query.Where( x=>x.Code == codePart || x.Description== codePart) 

but how can I create a query like this:

select * from n where the code is '% abc%' or a description of type '% abc%'

Answer 1

 query.Where(Restrictions.On<Type>(x => x.Code).IsLike(codePart) || Restrictions.On<Type>(x => x.Description).IsLike(codePart)) 

Answer 2

You can use the NHibernate Disjunction class to do this in a more elegant way (IMHO):

 var disjunction= new Disjunction(); disjunction.Add(Restrictions.On<Type>(e => e.Code).IsLike(codePart)); disjunction.Add(Restrictions.On<Type>(e => e.Description).IsLike(codePart)); //(and so on) 

and then:

 query.Where(disjunction) 

Each "OR" is a separate instruction that helps if you want to conditionally add predicates.

Answer 3

Another version of this that you may like depending on your taste is as follows:

 query.Where(Restrictions.Disjunction() .Add(Restrictions.On<Type>(e => e.Code).IsLike(codePart)) .Add(Restrictions.On<Type>(e => e.Description).IsLike(codePart)));