QueryOver IN Clause?

nhibernate queryover
Daniel Williams picture Daniel Williams · Aug 28, 2012 · Viewed 12.2k times · Source

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.

Answer

Daniel Williams picture Daniel Williams · Aug 28, 2012

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!

Related questions

NHibernate using QueryOver with WHERE IN

I would create a QueryOver like this SELECT * FROM Table WHERE Field IN (1,2,3,4,5) I've tried with Contains method but I've encountered the Exception "System.Exception: Unrecognised method call: System.String:Boolean Contains(System.String)" Here my code var qOver = _HibSession.…

Read More
How to get a distinct result with nHibernate and QueryOver API?

I have this Repository method public IList<Message> ListMessagesBy(string text, IList<Tag> tags, int pageIndex, out int count, out int pageSize) { pageSize = 10; var likeString = string.Format("%{0}%", text); var query = session.QueryOver<Message>() .Where(…

Read More
What is the difference between JoinQueryOver and JoinAlias?

I need to know what is the difference between JoinQueryOver and JoinAlias, and when to use each?

Read More