title: Linq to SQL multiple conditional where clauses
body: <p>At the moment I am retrieving my results as follows :</p>
  
  <pre><code>public List&lt;claim&gt; GetClaims()
  {
      return _db.claims.OrderBy(cl =&gt; cl.claimId).ToList();
  }
  </code></pre>
  
  <p>But now I am trying to add up to 8 conditional where clauses based on filters above my listview.</p>
  
  <p>So I turned into:</p>
  
  <pre><code>public List&lt;claim&gt; GetFilteredClaims(string submissionId, string claimId,
                                       string organization, string status,
                                       string filterFromDate, string filterToDate,
                                       string region, string approver)
  {
      return _db.claims.Where(cl =&gt; cl.submissionId == 5).ToList();
  }
  </code></pre>
  
  <p>How can I do a check for each filter to add a where clause only if they contain a value?</p>