NHibernate stored procedures - set parameter sizes?

Question

I am executing a stored procedure using GetNamedQuery and setting a string parameter using SetString . NHibernate sets the string parameter to NVarchar(4000) . My string parameter value is actually more than that, and therefore truncation happens.

Is there a way to tell NHibernate to use a longer string type when executing a query? The request is defined in the mapping file as simple. exec dbo.ProcessUploads :courseId, :uploadxml

Edit: none of my parameters are properties of the involved participants.

Answer 1

Since NHibernate does not have enough information to automatically set the parameter length, you must do this manually.

Example:

 session.GetNamedQuery("ProcessUploads") .SetParameter("courseId", courseId) .SetParameter("uploadXml", uploadXml, NHibernateUtil.StringClob) .ExecuteUpdate(); 

In this case, I use StringClob , which translates to NVARCHAR(max) .

Answer 2

You must show us or check your HBM file for parameters. There you can specify the type of field / property, length ...

Here you can read the official nHibernate documentation