title: Using a LINQ method with 2 Where clauses will not work for some reason
body: <p>I have a LINQ Method like this:</p>
  
  <pre><code>List&lt;string&gt; paths = db.ClientStatement_Inventory
                       .Where(x =&gt; x.statementYear == year)
                       .Select(c =&gt; c.statementPath).ToList();
  </code></pre>
  
  <p>The above method works perfectly and it puts the statement path into "paths" from the database depending on what year is checked.</p>
  
  <p>For some reason when I add another where clause it will not contact the db and put the any of the statement paths into the variable "paths". </p>
  
  <p>Here is my second linq method:</p>
  
  <pre><code>List&lt;string&gt; paths = db.ClientStatement_Inventory
                       .Where(x =&gt; x.statementYear == year)
                       .Where(x =&gt; x.statementMonth == month)
                       .Select(c =&gt; c.statementPath).ToList();
  </code></pre>
  
  <p>I am setting the year and month to a string like so:</p>
  
  <pre><code>for (int y = 0; y &lt; years.Length; y++)
              {
                  var year = "";
                  if (years.ToString() != "")
                  {
                      year = years[y];
                  }
  </code></pre>
  
  <p>I have tried multiple different ways to do the two where clauses from different stack overflow questions but nothing seems to work. I am not getting any error message when debugging and stepping through my code.</p>