读书人

哪位高手帮忙把这条sql 转成linq

发布时间: 2012-04-07 17:31:51 作者: rapoo

谁帮忙把这条sql 转成linq啊
select * from T_News join T_NewsClass on t_news.ID_NewsClass = T_NewsClass.ID order by T_NewsClass.id desc


谢谢~~
QQ : 820791660

[解决办法]
var query = from c in T_News
join o in T_NewsClass on c.ID_NewsClass equals o.ID_NewsClass
orderby o.T_NewsClass descending
select c;

[解决办法]
因为你的SQL语句是inner join
而你2楼的LINQ最终转化的是left join

读书人网 >.NET

热点推荐