Convert this sql to Entity Framework

1 posts, 0 answers
  1. Asaf
    Asaf avatar
    1 posts
    Member since:
    Jul 2012

    Posted 18 Jul 2012 Link to this post


    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.
Back to Top