title: Convert SQL subquery to EF Query using Lambda syntax
body: <p>Here is SQL Query,,, I have two <code>tables, one is Categories and other Sub Categories</code>,,, I want to use <code>inner query(Category table) and that value pass to outer query(Sub categories table)</code>
  How to convert it into Entity framework with lambda expression..?</p>
  
  <pre><code>select * 
  from DC_System_SubCategories 
  where CatID = (select max(CatID) 
                 from DC_System_Categories) 
  </code></pre>