title: T-SQL to LINQ conversion
body: <p>I have the following SQL statement</p>
  
  <pre><code>SELECT 
      c.CorpSystemID, c.SystemName  , 
      case when a.TaskItemID is NULL then 'false' else 'true' end as Assigned
  FROM CorpSystems c 
  LEFT OUTER JOIN
       (SELECT CorpSystemID, TASKItemID 
        FROM AffectedSystems 
        where TASKItemID = 1) a ON c.CorpSystemID = a.CorpSystemID
  </code></pre>
  
  <p>Can anyone please help me to convert this statement to LINQ?</p>
  
  <p>Thank you.</p>