title: LINQ Case When Query
body: <p>I have an SQL query like below in Oracle SQL syntax and I want it in LINQ equal.</p>
  
  <pre class="lang-sql prettyprint-override"><code>Select Case When tbl.Id=1 then 1 else NULL End as col1,
  Case When tbl.Id=2 then 2 else NULL End as col2,
  Case When tbl.Id=3 then 3 else NULL End as col3
  From Table1 tbl
  </code></pre>