QueryOver IN Clause?
nhibernate, queryover
Solution
Aha- got it! The AddRestrictions has an IsIn method:
var results = session.QueryOver<Foo>().AndRestrictionOn(x=>x.id).IsIn(ids)
With this last piece we might be ready to ditch our years-old hand-rolled ORM!
Problem
I want to simulate this query: ``` SELECT * FROM FOO WHERE ID IN (1,2,3) ``` How can I do this in FNH? ``` var ids = new List<int>{1,2,3}; var results = session.QueryOver<Foo>().Where( x=> ids.Contains(x.id) ); ``` But that does not work, just gives me an "unrecognized method call" exception. Any ideas? This must be a common request.