This is a migrated thread and some comments may be shown as answers.

Convert this sql to Entity Framework

0 Answers 66 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Asaf
Top achievements
Rank 1
Asaf asked on 18 Jul 2012, 09:57 AM
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.

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
Asaf
Top achievements
Rank 1
Share this question
or