title: last_insert_id ? C#, SQL Server and NHibernate
body: <p>I need to know how can I know what is the last inserted id in a SQL Server database for a  given table? </p>
  
  <p>I'm using <code>int identity</code> not guid and if it's matters NHibernate as my ORM. </p>
  
  <p>Thanks</p>