title: mvc entity framework select case when
body: <p>how can I translate this into LINQ? </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>Select
   Object =  case when C.Description='UPLOAD' 
              then (select SeekName from Uploads where Upload_id= C.Object_id)
         else case when C.Description='ACTIVITY'
    then (select Name from Activities  where Activity_id= C.Object_id)
    else (select SUBSTRING(Description,1,10) from Questions  where Question_id= C.Object_id)
    end
    end,
  From Contact C          </code></pre>
  </div>
  </div>
  </p>
  
  <p>I know that I case use <code>let</code> to replace <code>case when</code>. But i need to do a <code>Select</code> statement in each <code>case when</code></p>