title: Linq - how to filter dataset based on data in another table?
body: <p>I'm looking to filter the data in a dataset much like you'd do a <code>where &lt;value&gt; in (select &lt;value&gt; from other_table where year=2016)</code></p>
  
  <p>So I have a list of the "values":</p>
  
  <pre><code>var BUs = (from b in dc.BusinessUnits
  where b.Year == int.Parse(ddlYears.SelectedValue)
  orderby b.BuName
  select new { b.BUID }).ToList();
  </code></pre>
  
  <p>So what I need to do is filter this dataset based on the BUID list returned in the BUs var.</p>
  
  <pre><code>IQueryable&lt;Market&gt; markets = (from p in dc.Markets
  orderby p.MarketName
  select p);
  </code></pre>
  
  <p>Help? I'm 100% new to linq so I need a concise solution.</p>