Hi. How can I do a group by in LINQ to SQL... I do not want to use a stored procedure and the documentation for Group By just does not help me enough.... I have a table called songs, artist and then songs2artists. I want to get all songs and artists but group them by songs(A song can be a cover version by a few artists) so I thought of using FirstOrDefault but the problem is that a song - artist can be repeated 5 times, each for a different record label. The LINQ that i have to get my result set
Read More...