Convert this sql to Entity Framework
Posted: Wed 18 Jul 2012 23:00
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
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