title: query did not return a unique result: 2 . Issue with Nhibernate Query
body: <p>I am current having an issue with getting records from database using <code>nhibernate</code>.</p>
  
  <p>My 'publicstring' column is having two values, one with lower case and the other with upper case.
  I am trying to fetch one of them depending on what is typed.</p>
  
  <p>Below is my query</p>
  
  <pre><code> private string _publicId;
   var _mediaFileShare = this.Session.QueryOver&lt;MediaFileShare&gt;()
                                     .Where(q =&gt; q.Publicsting == _publicstring)
                                     .SingleOrDefault();
  </code></pre>
  
  <p>Answers would be appreciated..</p>