sql语句转linq

[linzonghua234]

select name from category where id not in (select parentid from category where parentid is not null)

这是我的SQL语句，现在我要转化成linq写法，都写不成功,求高手帮帮忙啊，帮我一下啦。

[heimirror]

sf
不熟悉linq，帮你顶一下

[jian_xiaowei]

from n in category
where !( from m in category where m.parentid!=null select m.parentid).contain(n.id)
select n.name

[SlaughtChen]

顶了