title: How to convert this SQL to LINQ of ASP.NET MVC?
body: <p>I have this SQL statement:</p>
  
  <pre><code>select 
      table1.DIRECTORATE_ID, 
      table2.PLA_NAME + '//' + table1.ENGLISH_DIRECTORATE_CODE as EngCode
  from table1
  inner join table2 on table1.PLA_ID = table2.PLA_ID order by EngCode
  </code></pre>
  
  <p>I need to do the same type of query in my EF code that gives me a <code>List&lt;&gt;</code>. Something like this:</p>
  
  <pre><code>var query = (from t1 table1.DIRECTORATE_ID, table2.PLA_NAME + '//' + table1.ENGLISH_DIRECTORATE_CODE as EngCode
               from table1
               inner join table2 on table1.PLA_ID = table2.PLA_ID order by EngCode)
              .ToList();
  </code></pre>