title: NHibernate stored procedures - set parameter sizes?
body: <p>I'm executing a stored procedure using <code>GetNamedQuery</code> and setting a string parameter using <code>SetString</code>. NHibernate sets the string parameter to be an <code>NVarchar(4000)</code>. My string parameter value is actually longer than this and so gets truncated.</p>
  
  <p>Is there any way to tell NHibernate to use a longer string type when executing the query? The query is defined in the mapping file as simply. <code>exec dbo.ProcessUploads :courseId, :uploadxml</code></p>
  
  <p>Edit: neither of my parameters are properties of the enties involved.</p>