Hi folks,
i have a table that has zero to many children. just like how this site has a QUESTION
which can have zero to many VOTES
(either Up == 1 or Down == 0).
I need to get all questions that have the most up votes. Eg. all the questions, ordered by Sum(Vote) descending.
I'm not sure how to do it in linq.
So i would have an EntitySet called Questions and another EntitySet called Votes.
I was trying to do group by and let and order by and nothing compiles :(
Could anyone have any suggestions, please?