title: NHibernate CreateSQLQuery
body: <p>Im trying to get some data with NH CreateSQLQuery method like</p>
  
  <pre><code>IList&lt;Logistic&gt; LCollection = sess.CreateSQLQuery(@"select * from some_schema.logistic")
                                             .SetResultTransformer(Transformers.AliasToBean(typeof(Logistic)))
                                             .List&lt;Logistic&gt;();
  </code></pre>
  
  <p>logistic class is</p>
  
  <pre><code>public class Logistic
  {
      public virtual long? l_id { get; set; }
      public virtual long? carrier_id { get; set; }
      ...
  }
  </code></pre>
  
  <p>mapping</p>
  
  <pre><code>public class LogisticMap : ClassMap&lt;Logistic&gt;
  {
      public LogisticMap()
      {
          Table("some_chema.logistic");
          Id(x =&gt; x.l_id).GeneratedBy.Sequence("some_chema.logistic_sq");
          Map(x =&gt; x.carrier_id);
          ...
      }
  }
  </code></pre>
  
  <p>but i have the error </p>
  
  <pre><code>The type System.Decimal can not be assigned to a property of type System.Nullable`1[System.Int64] setter of MyNamespase.Logistic.l_id
  </code></pre>
  
  <p>any idea what may be wrong?</p>