QueryOver IN Clause?

Question

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.

possible duplicate of [NHibernate using QueryOver with WHERE IN](http://stackoverflow.com/questions/5408781/nhibernate-using-queryover-with-where-in) — Stefan Steinegger, Jun 19 '15 at 08:43

score 41 · Accepted Answer · answered Aug 28 '12 at 08:15

41

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!

answered Aug 28 '12 at 08:15

Daniel Williams

1

Just amazingly simple! Thanks! – Guillermo Gutiérrez Feb 21 '13 at 14:50
2

[Here's a Gist](https://gist.github.com/kenny-evitt/9121755) with an example of the SQL generated by this. – Kenny Evitt Feb 20 '14 at 19:49
1

You can also use WhereRestrictionOn instead of AndRestrictionOn – maxspan Sep 23 '14 at 03:40
what is the definition of the "ids" ? – Juran Jul 15 '16 at 08:31

1 Answers1