I'm trying to emulate subject query with NHibernate's IQueryOver
. So far I have
var q = CurrentSession.QueryOver<ObjectModel.Order>().
WhereRestrictionOn(o => o.Buyer.ID).IsIn(partyIDs).
WhereRestrictionOn(o => o.Seller.ID).IsIn(partyIDs);
This, however, generates an and
query, whereas I need to have an or
operator between two where
clauses.
How is this done with IQueryOver
?
As it usually is, found question soon after explaining the problem to general public. Thanks, guys!
var q = CurrentSession.QueryOver<ObjectModel.Order>();
q.RootCriteria.Add(Restrictions.Or(
Restrictions.On<ObjectModel.Order>(o => o.Buyer.ID).IsIn(partyIDs),
Restrictions.On<ObjectModel.Order>(o => o.Seller.ID).IsIn(partyIDs)));
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With