title: IQueryable.Where clause AND not working with multiple search parameters
body: <p>I am having an issue with getting a Multiple search working with a IQueryable.Where Clause using the AND operator.  I know that the problem is when a parameter is blank or null it is searching for a "" with the other parameter and not returning results but I don't want to have to go through an extended and ridiculously nested if to check for nulls or blanks on 8 parameters.  I have googled this for days, the OR works obviously but the AND condition returns nothing.</p>
  
  <pre><code>albums = albums.Where(a =&gt; a.CA_AlbumName.ToUpper().Contains(searchName.ToUpper()) &amp;&amp; 
                             a.CA_AlbumURL.ToUpper().Contains(searchURL.ToUpper()));
  </code></pre>
  
  <p>The above works if both parameters are not blank but returns nothing if one of them is.  I have tried building the where based on not null like below but same results:</p>
  
  <pre><code>if (!String.IsNullOrEmpty(searchName))
  {
      albums = albums.Where(a =&gt; a.CA_AlbumName.ToUpper().Contains(searchName.ToUpper()));
  }
  if (!String.IsNullOrEmpty(searchURL))
  {
      albums = albums.Where(a =&gt; a.CA_AlbumURL.ToUpper().Contains(searchURL.ToUpper()));
  }    
  </code></pre>