title: How to get max value from one table, then join another table using Entity Framework 6
body: <p>I have 2 tables <code>stock</code> and <code>stockprice</code>. I want to get all stocks with their last updated price using Entity Framework 6.</p>
  
  <p>I first <code>select * from stock</code>, then use foreach to get last updated price for each symbol. How can do that with just one query using entity framework 6?</p>
  
  <p><strong>Stock</strong>:</p>
  
  <pre><code>Id    Symbol
  -------------
  1     AAPL
  2     MSFT
  </code></pre>
  
  <p><strong>Stockprice</strong>:</p>
  
  <pre><code>Id   Symbol   Price   LastUpdatedDate    
  -------------------------------------
  1    AAPL      120    11/7/2016
  2    AAPL      121    11/2/2016
  3    AAPL      123    11/3/2016
  4    MSFT      111    11/2/2016
  5    MSFT      101    11/6/2016
  </code></pre>
  
  <p>I want to get last updated price for each symbol.</p>
  
  <pre><code>AAPL  120  11/7/2016
  MSFT  101  11/6/2016
  </code></pre>