title: Linq query with string array in where clause
body: <p>I have the following LINQ query where clause which isn't returning the expected result. <code>dtTemp row.Item(0)</code> has values like <code>"GE", "LE", "ST", "PL"</code> while <code>Stkyard</code> is a string array with one or more of these values.</p>
  
  <p>I am expecting the below query to filter values based on entry in <code>Stkyard</code> but the returned result set has sum of all values in <code>dtTemp</code> </p>
  
  <pre><code>dtQuery = (From row In dtTemp
             Group row By grp = 
             New With {Key .mth = row.Item(1), Key .mthdesc = row.Item(2)} Into Group, 
             val1 = Sum(Convert.ToDecimal(row.Item(3))), val2 = Sum(Convert.ToDecimal(row.Item(4)))
             Where Group.Any(Function(p) Stkyard.Contains(p.Item(0)))
             Select New With {grp.mth, grp.mthdesc, val1, val2}
             Distinct).ToList
  </code></pre>
  
  <p>Any help?</p>
  
  <p>DonNetFiddle <a href="https://dotnetfiddle.net/WC8LcD" rel="nofollow">Example</a></p>