问如何使用LINQ获得按产品组分类的畅销书

EN

{  
    public ActionResult Query2()
    {
        // this part gets me everything into one model type 
        List<QueryViewModel> result = db.SaleProducts
            .GroupBy(prod => prod.Type)
            .SelectMany(sale => sale.Select(
                row => new QueryViewModel
                {
                    Seller = row.Sale.User.Name,
                    ProductType = row.Type,
                    Sales = (double)sale.Where(x => x.Sale.UserId == row.Sale.UserId && x.Type.Equals(row.Type)).Sum(price => price.Price)
                }
            )).Distinct().ToList<QueryViewModel>();

        // this gives me the best per product type but i cant get the seller name 
        List<QueryViewModel> filter = (from res in result
                                       group res by res.ProductType into prodGroup
                                       select new QueryViewModel
                                       {
                                           ProductType = prodGroup.Key,
                                           Sales = prodGroup.Max(x => x.Sales)
                                       }).ToList<QueryViewModel>();

        // this is really just to get the seller name at this point 
        List<QueryViewModel> something = (from res in result
                                          join f in filter on res.Sales equals f.Sales
                                          select new QueryViewModel
                                          {
                                              Seller = res.Seller,
                                              ProductType = res.ProductType,
                                              Sales = res.Sales
                                          }).ToList<QueryViewModel>();

        return View(something);
    }
}