Richard, would be possible the same solution adopted for "IsLike" ?
On Sun, Jul 18, 2010 at 7:50 AM, Richard Brown (gmail) < [email protected]> wrote: > I thought you could also do this: > > criteria.Where(Restrictions.On<Listing>(l => l.Id).Not.IsIn(ClickedItems > )); > > ... but it looks like I missed that syntax (my mistake - I'll add it). You > could also (assuming the IQueryOver has the required types) use: > > criteria.WhereRestrictionOn(l => l.Id).Not.IsIn(ClickedItems); > > *From:* Cristian Prieto <[email protected]> > *Sent:* Friday, July 16, 2010 6:47 PM > *To:* [email protected] > *Subject:* Re: [nhusers] Not In with QueryOver > > That was my first thought... but It was too much easy to be true... :P > > Now I love QueryOver even more than before :) > > -- Cristian > > > On Fri, Jul 16, 2010 at 11:19 AM, Fabio Maulo <[email protected]>wrote: > >> Have you tried this >> >> criteria.Where(!Restrictions.On<Listing>(l => l.Id).IsIn(ClickedItems)); >> >> >> On Fri, Jul 16, 2010 at 1:59 PM, Cristian Prieto >> <[email protected]>wrote: >> >>> Hi pals, >>> >>> I've been playing a little with new QueryOver with NH trunk, I really >>> love it... But after reading and searching a little in internet I could not >>> find how to do a "Not In" query using QueryOver and turns this into a >>> negative query: >>> >>> Snippet >>> >>> SnippetISession session = Factory.GetCurrentSession(); >>> IQueryOver<Listing, Listing> criteria = session.QueryOver<Listing>(); >>> >>> >>> >>> >>> >>> criteria.Where(Restrictions.On<Listing>(l => l.Id).IsIn(ClickedItems)); >>> >>> I mean, *IsIn* must become a *IsNotIn*... >>> >>> Thanks a lot for your help! >>> >>> -- Cristian >>> >>> -- >>> 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]<nhusers%[email protected]> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/nhusers?hl=en. >>> >> >> >> >> -- >> Fabio Maulo >> >> -- >> 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]<nhusers%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- Fabio Maulo -- 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.
