title: How to "SET NOCOUNT ON" for Nhibernate generated select statements
body: <p>We have "SET NOCOUNT OFF" by default on our database server.We use "SET NOCOUNT ON" for store procedures.
  As reported by dba's that all nhibernate generated select statements are using "SET NOCOUNT OFF". Which is taking long for queries to execute. 
  We are trying to increase the performance.I can not figure out the way to set "SET NOCOUNT ON" for specific nhibernate session or query. Can someone have some opinion about that.</p>
  
  <p>Regards</p>