LINQ is great, but it can be difficult to get the exact SQL you need. I just want to emit "select count(*) from table where parentid=3" ..