Array parameters in ISession.Find

lorenzo · **Posted:** Fri Aug 05, 2005 7:32 am

hi!

I'm quite new to NH, what I've seen till now is great!

I ask for help because I don't understand how to use the ISession.Find(string query, object value, IType type) function with an array parameter.

the query is:
from Appointment as appointment where appointment.Day in (?)

the value is an array of DateTime.

what is the correct type to use? the ObjectType doesn't work, while the ArrayType constructor asks me for a role parameter that I ignore.

thank you
lorenzo

michal · **Posted:** Sat Aug 06, 2005 6:21 am

I'm not sure about ISession.Find but I suggest using a query:

Code:

String sql = "from Cat cat where cat.id in (:keys)";
IQuery q = mySession().createQuery(sql); 

And then use

Code:

q.setParameterList("keys",...)

to bind a collection (array) parameter.