Thanks,
var result = from r in smdt.SM_RatedProducts
group r by new { r.SM_Product.Name, UserName = r.SM_User.Name, Category = r.SM_Product.SM_Category.Name, r.Rating } into prodGroup
orderby prodGroup.Key.UserName ascending
orderby prodGroup.Key.Category ascending
select new { prodGroup.Key.UserName, prodGroup.Key.Category, prodGroup.Key.Name, prodGroup.Key.Rating };
Mine one should not be as complicated though.
Anyone could give me a tiny hint on how to achieve above?