title: NHibernate - CreateSqlQuery returns only one row
body: <p>I am new to nhibernate... i have created a an SQL query (hits an Oracle database), that returns custom result set like this...</p>
  
  <p><img src="https://i.stack.imgur.com/WLaiS.png" alt="enter image description here"></p>
  
  <p>I try to map these results into a custom object like this...(this object is not a persistant object and does not contain a nhibernate mapping file)
    <img src="https://i.stack.imgur.com/xiwtN.png" alt="enter image description here"></p>
  
  <p>The problem is that when i execute this sql query in the Oracle database it gives me all 4 records, however if when i execute this from the code , i get only one record (result as only one item).</p>
  
  <p>Am i doing anythign wrong here?</p>