title: I need to Convert from SQL Query into LINQ/Lambda Expression
body: <p>I need to convert this sql statement into LINQ/Lambda Expression which I am unable to find online .Can anyone help with this</p>
  
  <pre><code>select  distinct o.ownerid ,a.acctnumber , c.cr_rpt_type_value ,c.cr_req_ts ,d.creditscore from Owner o 
  inner join AcctOwner a
  on o.ownerid =a.ownerid
  left join (
  select * from Cr_Rpt_Type x where x.cr_req_ts = (select MAX(cr_req_ts) from 
  Cr_Rpt_Type y where 
  x.cr_rpt_type_value= y.cr_rpt_type_value)) c on c.cr_rpt_type_value = o.ssn_vault_ref_number
  left join Cr_Rpt_Type_dms d on d.Cr_Rpt_Rspn_id_dms = c.Cr_Rpt_Rspn_id
  </code></pre>