title: SQL to LINQ orderby specific order
body: <pre><code>select Priority, 
    case Priority 
      when 'Medium' then (Count(*)* 100 / (Select Count(*) From #tem where Priority = 'Medium')) 
      when 'High' then (Count(*)* 100 / (Select Count(*) From #tem where Priority = 'High')) 
      when 'Low' then (Count(*)* 100 / (Select Count(*) From #tem where Priority = 'Low')) 
      when 'Critical' then (Count(*)* 100 / (Select Count(*) From #tem where Priority = 'Critical')) 
    end as '% SLM Met' 
  from #tem where Bool = 'True' 
  group by Priority
  order by 
    case Priority
       WHEN 'Critical' THEN 1
       WHEN 'High' THEN 2
       WHEN 'Medium' THEN 3
       WHEN 'Low' THEN 4
     End
  </code></pre>
  
  <p>How can we convert this into linq..</p>
  
  <p>I want to specify this order so as to get my UI right..</p>