title: LINQ-to-SQL Query Returning No Results
body: <p>I have a query using LINQ-to-SQL. It queries an underlying database table Rooms. It uses Where conditions to narrow down the results, namely:</p>
  
  <ol>
  <li>Gender.</li>
  <li>Current Occupancy &lt; Max Occupancy</li>
  <li>Available Flag is Checked</li>
  </ol>
  
  <p>I know this should return results but it keeps returning an empty set. Any ideas? Code is below</p>
  
  <pre><code>    Dim selectedHalls = (From sh In dbHalls.Rooms _
                           Where sh.gender = Session("gender").ToString _
                           Where sh.max_occupancy &gt; sh.current_occupancy _
                           Where sh.is_available = 1 _
                           Select sh.building_name).Distinct()
  </code></pre>
  
  <p>UPDATE: I've verified that the issue is with the statement where sh.is_available = 1, which doesn't make sense since this is a bit field.</p>