DetachedCriteria with 3 OR conditions

Question

How can I achieve this query using DetachedCriteria:

Select * from 
    MyTable
Where 
    (conditionA = true) or 
    (conditionB = true) or 
    (conditionC = true) or 
    (conditionD = true)

Answer 1

Like this:

DetachedCriteria.For<MyTable>()
        .Add(Restrictions.Eq("conditionA", true) ||
             Restrictions.Eq("conditionB", true) ||
             Restrictions.Eq("conditionC", true) ||
             Restrictions.Eq("conditionD", true));

Answer 2

You can use the Disjunction class like so:

DetachedCriteria.For<MyTable>()
        .Add(Restrictions.Disjunction()
             .Add(Restrictions.Eq("conditionA", true))
             .Add(Restrictions.Eq("conditionB", true))
             .Add(Restrictions.Eq("conditionC", true))
             .Add(Restrictions.Eq("conditionD", true)));