title: Set TimeOut Expired in NHibernate
body: <p>I have a stored procedure in sql server 2008 R2 which was working fine, but suddenly it throws an exception of TimeOut Expiration.</p>
  
  <pre><code>BmDaoSession.CreateSQLQuery("exec SP_Name @Param1  = '" + clientCode + "', @Param2 ='" + existingDatabase + "', @Flag='" + flag + "'").ExecuteUpdate();
  </code></pre>
  
  <p>I am using the above NHibernate command to call my SP. </p>
  
  <p>My question is how Can I set the TimeOut Expiration in NHibernate. Thanks</p>