title: Select Multi fields in Entity framework in c#
body: <p>I want to select 2 or more fields like this: for example we have a list of some people and now they say find people who is male and live in New York<br>
  we have 2 fields in here "City" and "Sexual".</p>
  
  <p>I can do it like this</p>
  
  <pre><code>private List&lt;tblTest&gt; GetAll(string city, string sexual)
  {
      var all = (from x in db.tblTest
                 where x.city == city &amp;&amp; x.sexual == sexual
                 select x).ToList();
      return all;
  }
  </code></pre>
  
  <p>and this one is not helping:</p>
  
  <pre><code>private List&lt;tblTest&gt; GetAll(string city, string sexual)
  {
      var all = (from x in db.tblTest
                 where x.city == city || x.sexual == sexual
                 select x).ToList();
      return all;
  }
  </code></pre>
  
  <p>with "<code>&amp;&amp;</code>" I can do it but if I want to just select "<code>City</code>" it is not working, and I want to search like this for 14 fields and we want to search for some fields not all fields we have and we don't know which fields we want to search       </p>
  
  <p>What should I do?</p>