Convert this sql to Entity Framework

[asaf_messika]

Hello,

I'm want to convert this sql query to Entity Framework,
how can I do it?

this is the code(found the popular HobbyCode):

select HobbyCode,count(HobbyCode)
from UserFavorites
group by HobbyCode
having count(*) >= all (select count(HobbyCode)
from UserFavorites
group by HobbyCode);

Thanks a lot.
Asaf

[Shalex]

Sorry but this question exceeds the goals of our support (non provider-specific). We recommend you to post it at http://www.stackoverflow.com.