title: bool column in where clause - linq/c#
body: <pre><code> Expression&lt;Func&lt;Employee, bool&gt;&gt; employeeWhere = R =&gt; true;
   employeeWhere = R =&gt; R.PositionCode == "M";
   employeeWhere = R =&gt; R.IsActive; //want only ones which are true
  </code></pre>
  
  <p>Will the above build me a query of this :</p>
  
  <pre><code>SELECT * FROM EMPLOYEE 
  WHERE POSITIONCODE = "M" &amp;&amp; IsActive = 1
  </code></pre>
  
  <p>This is what I want to return</p>
  
  <pre><code> var result = _db.Employees
                .Where(employeeWhere)
                .Select(p =&gt; new { p.EmployeeID, p.FName, p.MName, p.LName })
                .AsEnumerable()
                .ToDictionary(kvp =&gt; kvp.EmployeeID, kvp =&gt; kvp.FName + " " + kvp.MName + " " + kvp.LName);
  
          return new SelectList(result, "Key", "Value");
  </code></pre>