linq表达式错误：无法显示列名

发布于 2024-12-07 10:49:26 字数 372 浏览 2 评论 0原文

我正在使用 LinqPad 4（坚果壳数据库），我试图显示（客户）名称，它是客户表中的一列。我如何在此查询中显示名称，因为现在我收到错误：不包含“名称”的定义？

   from p in Purchases 
join c in Customers on p.CustomerID equals c.ID
group p by p.Date.Year into SalesPerYear
select new {
customername= SalesPerYear.First().Name,
customerid= SalesPerYear.First().CustomerID,
totalsales= SalesPerYear.Sum(x=>x.Price)
}

原文

I am using LinqPad 4(nutshell database) and I am trying to display the (Customer) Name which is a column in the Customer table.
How can i display the Name in this query because now I am getting an error: does not contain a definition for 'Name'?

   from p in Purchases 
join c in Customers on p.CustomerID equals c.ID
group p by p.Date.Year into SalesPerYear
select new {
customername= SalesPerYear.First().Name,
customerid= SalesPerYear.First().CustomerID,
totalsales= SalesPerYear.Sum(x=>x.Price)
}

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

吹泡泡o 2024-12-14 10:49:26

试试这个...

我假设您有一个包含（价格、客户 ID 和日期）列的购买表..

from p in Purchases  
group p by p.Date.Year into SalesByYear 
select new { 
customerid = SalesByYear.First().CustomerID, 
year=SalesByYear.Key, 
TotalVal = SalesByYear.Sum(g => g.Price) 
}

Try this...

I assume you have a Purchase table with (Price, CustomerID and Date) columns..

from p in Purchases  
group p by p.Date.Year into SalesByYear 
select new { 
customerid = SalesByYear.First().CustomerID, 
year=SalesByYear.Key, 
TotalVal = SalesByYear.Sum(g => g.Price) 
}

回复收藏 0 原文