So I got

IList enrollments = sess.CreateCriteria(typeof(Enrollment))
   .Add( Expression.Like("Name", "Tester")
   .CreateCriteria("User")
       .Add( Expression.Like("UserName", "Tester") )
   .List();

this assume that we got a class Enrollment with that have an
EnrollmentProperty

this generate an SQL where clause like this

WHERE  (enrollment_.Name like 'Tester')
      *and *(user_.UserName like 'Tester' )

how do modify my criteria so the and will become the or? like this
WHERE  (enrollment_.Name like 'Tester') *or *(user_.UserName like 'Tester' )

Thanks,

Hoang

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to