Hi!

Try .SetParameterList

On 2 Dec, 13:41, eigeneachse <[email protected]> wrote:
> h...@all,
> i have the following Method
>
> public IList<MyObject> RefreshSeats(Int64 anId, List<int>
> objectIdList) {
>     try {
>
>         return Session.CreateQuery
>             (@"
>             select s
>             from MyObject s
>             where s.anId = ?
>             and s.objectId in (?)")
>              .SetParameter(0, anId)
>              .SetParameter(1, objectIdList)
>              .SetCacheable(true)
>              .SetCacheMode(CacheMode.Refresh)
>              .List<MyObject>();
>     }
>     catch (Exception e) {
>         throw e;
>     }
>
> }
>
> if i try to execute the query i got the following error
>
> (ORA-00932: inconsistent datatypes: expected NUMBER got BINARY)
>
> How can i give nhibernate a list of parameters. Is there another way
> to do that?
>
> Thanks in advance.
>
> Regards
>
> eigeneachse

--

You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.


Reply via email to