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

NhibernateQueryover

Nhibernate Problem Overview


Is there any elegant way of combining 'like' and 'or' when i'm using queryover 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 code like > '%abc%' or description like '%abc%'

Nhibernate Solutions


Solution 1 - Nhibernate

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

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, which helps if you want to add the predicates conditionally.

Solution 2 - Nhibernate

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

Solution 3 - Nhibernate

Another version of this, which depending on taste, you may like, 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)));

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionbuddyView Question on Stackoverflow
Solution 1 - NhibernatepsousaView Answer on Stackoverflow
Solution 2 - NhibernateDiego MijelshonView Answer on Stackoverflow
Solution 3 - NhibernatePlebsoriView Answer on Stackoverflow