title: Write LINQ subquery C#
body: <p>I need to write below sql query in <code>linq</code>. i wrote <code>linq</code> query for this with out sub query part. i have no idea about how to write sub query in <code>linq</code></p>
  
  <pre><code>select * from PART_TYPE Pt
  left join 
  (select * from PART_AVAILABILITY where DATE_REF = '2013-06-20')pa
  on Pt.PART_TYPE_ID = pa.PART_TYPE_ID
  where Pt.VEHICLE_ID = 409
  </code></pre>
  
  <p>How can i do this ?</p>