About Criteria query??for three or more 'or' ??

yoty · **Joined:** Fri May 09, 2008 11:55 pm **Posts:** 2

I've a sql sentence:
select * from student where name='a' or name='b' or name ='c' or name ='d' or.......

I want to use Criteria query to implement it !
How Can I do this?
I almost wasted my whole day for that problem!!!!!for help in hurry!!!

THanks ,THX!!!!!!!!!!!!!!!!!!

wolli · **Posted:** Wed May 28, 2008 7:24 am

If you query on different properties, you can do

Code:

criteria.Add(Expression.Disjunction()
    .Add(Expression.Eq("A", a))
    .Add(Expression.Eq("B", b))

or if it's all about one property:

Code:

criteria.Add(Expression.In("Name", stringArrayOfNames));

yoty · **Joined:** Fri May 09, 2008 11:55 pm **Posts:** 2

wolli wrote:

If you query on different properties, you can do

Code:

criteria.Add(Expression.Disjunction()
    .Add(Expression.Eq("A", a))
    .Add(Expression.Eq("B", b))

or if it's all about one property:

Code:

criteria.Add(Expression.In("Name", stringArrayOfNames));

thX a lot ! i know the Disjunction()! but i do not know it has add() function!
i will carefull for this !
thX again!