Use OR Clause in queryover in NHibernate
Here is description how we can build OR with NHiberante
The syntax (in C# as the tag says) is:
Restrictions.Or(restriction1, restriction1)Restrictions.Disjunction().Add(restriction1).Add(restriction2).Add(...
In this case, it could be like this (again in C#, while question seems to use VB):
db.QueryOver<Users>()() .Where((x) => x.Role == "Guest") .And(Restrictions.Or( Restrictions.Where<Users>((x) => x.Block == 0) , Restrictions.Where<Users>((x) => x.APPID == appId) )) .List<Users>();