Linq to SQL Select 中的分组依据和求和

我需要将该 SQL 查询转换为 Linq：

SELECT
    SUM([ArticleAmount]) as amount
    ,[ArticleName]
FROM [DB].[dbo].[OrderedArticle]

group by articlename

order by amount desc

我尝试了以下代码，但在“a.ArticleName”处收到错误，表示缺少“ArticleName”的定义。

var sells = orderedArt
            .GroupBy(a => a.ArticleName)
            .Select(a => new {Amount = a.Sum(b => b.ArticleAmount),Name=a.ArticleName})
            .OrderByDescending(a=>a.Amount)
            .ToList();

你们有人知道如何解决这个问题吗？

感谢您的帮助！

您收到此错误是因为分组未返回IEnumerable<OrderedArticle> but IEnumerable<IGrouping<string, OrderedArticle>>

您需要更改代码才能使用a.Key:

var sells = orderedArt
    .GroupBy(a => a.ArticleName)
    .Select(a => new { Amount = a.Sum(b => b.ArticleAmount), Name = a.Key})
    .OrderByDescending(a => a.Amount)
    .ToList();