title: SQL query on Entity Framework
body: <p>How do I do this sql query to entity framework?</p>
  
  <pre><code>select 
  id,
  column1,
  column2 =  case when (select max(column2) from table1 b where b.id = a.id) = a.column2 
  then 'Positive' else 'Negative' end
  from table1 a
  </code></pre>