entities 可以实现sql case ... when ...then 排序吗？

select HJ_AllNews.MediaName,HJ_AllNews.ClipTime,convert(varchar(10),HJ_AllNews.ClipTime,120) as ClipTime2, _Lexus_Clippings.ClientPressReleaseID,_Lexus_Clippings.ClientMediaTypeID, _Lexus_Clippings.ID as ClientObjID, _Lexus_Clippings.ClientCatalogID as ClientCatalogID,HJ_AllNews.* from HJ_AllNews join _Lexus_Clippings on HJ_AllNews.ID=_Lexus_Clippings.ClippingsID join ClientDailyReport on _Lexus_Clippings.ID=ClientDailyReport.ClientClipID where ClientDailyReport.ClientDailyCatalogID=@DailyCatalogID order by ClipTime2 DESC,HJ_AllNews.MediaTypeID, case HJ_AllNews.MediaName when '腾讯网' then 1 when '搜狐网' then 2 when '网易' then 3 when '新浪网' then 4 else 5 end,HJ_AllNews.MediaName

请问：case HJ_AllNews.MediaName when '腾讯网' then 1 when '搜狐网' then 2 when '网易' then 3 when '新浪网' then 4 else 5 end

这样的排序用entities 如何实现呢？高手指教

最简单的方法套个子查询

select * from (你的sql语句) order by 排序字段

最简单的方法套个子查询

select * from (你的sql语句) A order by 排序字段

我是想用 linq 4.0 entity 实现

有什么区别么？你实体直接用子查询结果就是了

给个例子 子程序怎样写在List<T>查询中