join a in ... into ta select ...Status = ra != null ?:语法确定的,该语法由LINQ自动翻译(我想是一棵表达式树,我想,SQL日志最后显示了一个CASE WHEN查询)。QueryStatusExpression() return ra => ra !... : ...;然后用它就像
Status = QueryStatusExpr
SELECT * WHERE Subscription_Id = @Subscription_Id) AS RAON (CONVERT(date, Last30Days.DateValue) = CONVERT(date, RA.RegistrationDate)) ASC) AS rowno,
Last30Days.DateValue AS down