title: LINQ get Max value from list
body: <p>I have the following table:</p>
  
  <pre><code> ID Amt  Received
   -- ---- --------
   2  55   N 
   2  88   Y
   2  44   N
   3  5    N
   3  9    N
   4  5    N
   5  33   Y
   6  43   N
   7  54   N
  
      var result = (from rs in db.Exp
                    where rs.ID == id
                    &amp;&amp; rs.Received == true
                    select rs).Max().Any();
  </code></pre>
  
  <p>Given an ID, I need to find the max Amt for a given id and then check if it is Y, if so, return true else return false.  </p>