HQL in operator and parameters

Question

Hello.

There is need for quering NHibernate for several instances of the entity. I've tried following code, but it failed with wired NRE indepth of NHibernate.

var query = NHibernateSession.CreateQuery("from User u where u.id in (:ids)");
query.SetParameterList("ids", new Guid[]);
query.ToList();

It looks like common problem - any suggestions?

Update This only occurs if array is empty - question closed.

Answer 1

:ids would be an empty Guid array, wouldn't it? You're asking NHibernate to give you users where the id is inside a non-initialized array of Guid.