title: Linq query with in clause and max
body: <p>I have a simple sql query but I cannot convert it to LINQ:</p>
  
  <pre><code>select * from client_software where update_date in 
      (select max(update_date) AS UPDATE_DATE from client_software a
          where a.client_code = client_software.client_code and
              a.software_code = client_software.software_code) 
  </code></pre>
  
  <p>Can somebody help?</p>