title: lambda and linq expression
body: <p>I am working on an asp.net mvc 5 application and I am trying to filter a list but I'll always get a bad result when I have a multiple selection. Im using a simple form with checkboxes to know which mission's criteria is selected.</p>
  
  <p>My Database:</p>
  
  <p>Table Mission has a list of criteria (Table: CriteriaList)</p>
  
  <pre><code>// public virtual ICollection&lt;Criteria&gt; CriteriaList { get; set; }
  
  int[] CriteriaSelected = List of criteria selected in the form
  
  var items = from i in db.Missions select i;
  
  foreach (var criteriaID in CriteriaSelected)
  {
    items = items.Where(m =&gt; m.CriteriaList.Any(c =&gt; c.CriteriaID == criteriaID ));
  }
  </code></pre>
  
  <p>I know it might be a problem with the 'and' operator used to concatenate the multiple "where" because I got the right result just for one checkbox selected. But I'm right now a little lost to do a multiple selection of criteria</p>
  
  <p>Your help is really appreciated</p>