C SQL到LINQ检查多个案例

如何在Linq中检查多个案例(将“高薪”、“低薪”、“中薪”分类)

SQL

select id,name,salary,
  case  when salary <=1500 then 'under paid'
        when salary >=3500 then 'over paid'
        else 'medium pay' end as status 
from Person

林克

   var q =
          context.Persons.
          Select(c => 
          new { 
               EmployeeID = c.Id,
               EmployeeName = c.name,
               EmployeeSalary = c.salary,
               Status = c.salary > 1000 ? "under paid" : "overpaid"
              }
            );

使用三元运算符,我可以检查其中一个或多个情况。否则,我必须使用if..else if。