How to set more than 2 Expression in Expression.Or

Question

I want to create a query which has more than 3-4 Expression.Or ? But Expression.Or just let me to add two Expressions inside it.

if (!string.IsNullOrEmpty(keyword))
                query
                    .Add(Expression.Or(
                             Expression.Like("Name", keyword, MatchMode.Anywhere),
                             Expression.Like("LastName", keyword, MatchMode.Anywhere)))
                    .Add(Expression.Or(
                             Expression.Like("Email1", keyword, MatchMode.Anywhere),
                             Expression.Like("Email2", keyword, MatchMode.Anywhere)));

The code above generates "Name like %this% or LastName like %this% AND Email1 like %this% and Email2 like %this.

Thanks in advance.

The following is something I found a while back for Entity Framework, the same code works with nHibernate : http://stackoverflow.com/questions/1554663/composing-linq-to-entity-query-from-multiple-parameters/1554759#1554759 — Alexandre Brisebois, Jul 18 '11 at 21:02
@Alexandre: your solution is for a LINQ provider. This question is about the NHibernate Criteria API. — Mauricio Scheffer, Jul 18 '11 at 22:18

Mauricio Scheffer · Accepted Answer · 2011-07-18T17:54:31.513

8

Use Disjunction instead of Or.

edited Jul 18 '11 at 17:54

answered Jan 12 '09 at 01:14

Mauricio Scheffer

98,863
23
192
275

Thank you very much, I have another question. I want to query another table while querying this one. Forexample i want to get Customers whose id = Group.CustomerId – Barbaros Alp Jan 12 '09 at 01:31
Please create another question for that, it's unrelated to this one. – Mauricio Scheffer Jan 12 '09 at 11:17
I really don't understand the point of using Disjunction when you have the Linq api and Expressions – Alexandre Brisebois Jul 18 '11 at 20:56
@Alexandre: take a good look at the date of the question and answer. Also, the question is tagged with 'criteria' – Mauricio Scheffer Jul 18 '11 at 21:40
@Alexandre: if there was a LINQ provider for NHibernate back then, it was the contrib provider which was quite broken. Criteria API was much more widely used. The built-in LINQ provider is a relatively recent addition. – Mauricio Scheffer Jul 18 '11 at 22:18

score 2 · Answer 2 · answered Jul 31 '09 at 08:04

2

You can also use || instead of Or( ) or Disjunction( ).

answered Jul 31 '09 at 08:04

Caro

91
1
4

How to set more than 2 Expression in Expression.Or

2 Answers2

Linked