title: Modify IList Query Statement
body: <p>I have the following statement, and I want to modify it to not select all tables.</p>
  
  <ol>
  <li>Exclude 2 columns <code>customerItemNo</code> and <code>manufacturerItemNo</code> in the <code>if</code>, and</li>
  <li>Exclude 2 columns <code>customerItemNoAppend</code> and <code>manufacturerItemNoAppend</code> in the <code>else if</code>.</li>
  </ol>
  
  <p>How can I do it?</p>
  
  <pre><code>if (p.UserInternal == 'Y' &amp;&amp; p.UserActive == 'Y')
      inventorySummary = DataProvider.SelectCondition&lt;Q_TBL_INVENTORY_SUMMARY&gt;
  (r =&gt; r.InventoryLocationNo == location);
  
  else if (p.UserInternal != 'Y' &amp;&amp; p.UserActive == 'Y')
      inventorySummary = DataProvider.SelectCondition&lt;Q_TBL_INVENTORY_SUMMARY&gt;
  (r =&gt; r.InventoryLocationNo == location &amp;&amp; (r.CustomerID == customerID || r.CustomerID == " "));
  
  else
      inventorySummary = new List&lt;Q_TBL_INVENTORY_SUMMARY&gt;();
  </code></pre>