title: how to find non null or string.empty columns using linq?
body: <p>here's my code. it works</p>
  
  <pre><code>var someField = "abc";
  
  var list = Entities.Where(x=&gt;SomeField).FirstOrDefault();
  </code></pre>
  
  <p>here's the problem, someField can also be null or string.empty. If someField is null or string.empty, I will select everything where  SomeField is null or string.empty.</p>
  
  <pre><code>var list = Entities.Where(x=&gt;SomeField  == null || SomeField == string.empty).FirstOrDefault();
  </code></pre>
  
  <p>right now, I have an if else statement to check if someField has value,then decided which query to use.</p>
  
  <p>I need to combine the 2 queries into one. because if there are fields we need to check, then this if else statemetn will get very long.</p>