title: Most efficient way to get MAX value of joined table in LINQ query using C#
body: <p>I am trying to find the most efficient way to get the most recent record in a joined table in LINQ.</p>
  
  <p>This query may handle thousands of records so I didn't want to perform a subquery.</p>
  
  <p>I need everything from items, but only the most recent date from the "Notes" table, whose field name is SubmittedDate.</p>
  
  <pre><code>var items = (from t1 in db.Items
                           from t2
                              in db.Notes
                             .Where(o =&gt; (t1.Item_ID == o.Item_ID))
                           select new ItemModel
                           {
                               Name = t1.Name,
                               MostRecentUpdate = t2.SubmittedDate &lt;== Need max value in model
                           });
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>