title: Deleting a row with custom sql statement in Nhibernate
body: <p>I am using NHibernate and have a requirement where in when i am deleting a row i should not hard delete the row instead update the status to delted and set few system properties like who deleted etc.</p>
  
  <p>For doing this i have decided to go with custom sql statement like.</p>
  
  <pre><code>&lt;sql-delete&gt;
    update PPDE set SysStatusID = 2 where PPDID =? 
  &lt;/sql-delete&gt;
  </code></pre>
  
  <p>in the sql statement i am able to get reference to just id , but how can i update the SysUserID to the user who delted this row.</p>
  
  <p>Basically how to set up dynamic paramater values in custom sql statements.</p>
  
  <p>Any help is greatly appreciated.</p>