请参看下文链接: http://lancefisher.net/blog/archive/2008/05/07/linq-to-sql---case-statements.aspx 转载于:https://www.cnblogs.com/buhaiqing/archive/2009/09/14/1566664.html