求解SQL翻译成LINQ语句 高手进


select top 5 c.name,c.userid,count(d.userid) from users_base c join game_user d on c.userid=d.userid group by c.name,c.userid


统计每个人玩游戏个数

O(∩_∩)O




[解决办法]
参考

SQL code

from c in Customersjoin p in Purchaseson c.ID equals p.CustomerIDgroup p.Price by p.Date.Year into salesByYearselect new{Year=salesByYear.Key,TotalValue =salesByYear.Sum()}      最后呈现两个内容，一个是年份，一个是所有客户消费的金额总和。     对应的SQL：SELECT SUM([t2].[Price]) AS [TotalValue], [t2].[value] AS [Year]FROM (    SELECT DATEPART(Year, [t1].[Date]) AS [value], [t1].[Price]    FROM [Customer] AS [t0]    INNER JOIN [Purchase] AS [t1] ON ([t0].[ID]) = [t1].[CustomerID]    ) AS [t2]GROUP BY [t2].[value]
[解决办法]
SQL code
(from c1 in cjoin d1 in don c.userid equals d.useridgroup d1.userid by {    c.name,    c.userid }into grouptableselect new {    names=grouptable.Key.name,    userid=grouptable.Key.userid,    countuserid=grouptable.Sum()    }).Take(5)