title: Nullable Bit field true or false detection
body: <p>If I have a nullable bit field (named 'Disabled') and the data is as follows:</p>
  
  <pre><code>ID | Name | Disabled
  --------------------
  1  | Mine | null
  2  | Yours| 1
  </code></pre>
  
  <p>If I then execute the following Linq To Entities statement no values are returned:</p>
  
  <pre><code>from r in Rates
  where r.Disabled != true
  select r
  </code></pre>
  
  <p>But If I execute this Linq To Entities statement:</p>
  
  <pre><code>from r in Rates
  where r.Disabled == true
  select r
  </code></pre>
  
  <p>It returns the expected one row with an ID of 2.</p>
  
  <p>I want the first statement to return row 1 where the value of the 'Disabled' field is null.</p>
  
  <p>Am I missing a trick here? Why does the first statement not return the null valued row?</p>
  
  <p><strong>Edit</strong> let me rephrase the question... Why isn't it returning the null rows? I know I can put in a simple null check.</p>