The PriceOffer
property is nullable of decimal
List<TopRated> TopRated = (from review in db.ProductReviews
group review by review.ProductID into product
select new TopRated
{
ProductName = product.Select(p => p.Products.Name).FirstOrDefault(),
Price = product.Select(p => p.Products.Price).FirstOrDefault(),
PriceOffer = product.Select(p => p.Products.PriceOffer).FirstOrDefault(),
ProductId = product.Key,
AverageRating = product.Average(p => p.Rating)
}).ToList();