Page 1 of 1

Convert this sql to Entity Framework

Posted: Wed 18 Jul 2012 23:00
by 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

Re: Convert this sql to Entity Framework

Posted: Wed 25 Jul 2012 13:47
by 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.