Croup By and count distinct for multiple fields

[zaharium]

I have a Table:
Id Room Object Stuff Colour
1 Room1 Table plastic white
2 Room1 Table plastic white
3 Room1 Chair wood black
4 Room2 Chair plastic white
5 Room2 Chair metal white
6 Room2 Table metal white
7 Room3 Table plastic white
8 Room3 Table wood white

Hi I'm trying by LINQ-query (VB.NET) to return a count for distinct value of Objects, Stuffs and Colours for every Room:
Room Object Stuff Colour
Room1 2 2 2
Room2 2 2 1
Room3 1 2 1