怎么把这个sql语句改成linq语句 在线等答案
select*from(SELECTROW_NUMBER()OVER(PARTITIONBYuserclassORDERBYDownNumDESC)asrid,*FROM...
select * from(
SELECT ROW_NUMBER() OVER(PARTITION BY userclass ORDER BY DownNum DESC) as rid,*
FROM ShopList)a
WHERE Id='xxx' 展开
SELECT ROW_NUMBER() OVER(PARTITION BY userclass ORDER BY DownNum DESC) as rid,*
FROM ShopList)a
WHERE Id='xxx' 展开
展开全部
SQL中有函数如ROW_NUMBER()，无法转成Linq的，用存储过程或者视图来做吧。
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
SELECT * ,
row_num = ( SELECT COUNT(1)
FROM ShopList c2
WHERE c2.DownNum < c1.DownNum
) + 1
FROM ShopList c1 WHERE Id='xxx'
row_num = ( SELECT COUNT(1)
FROM ShopList c2
WHERE c2.DownNum < c1.DownNum
) + 1
FROM ShopList c1 WHERE Id='xxx'
追问
这个还是sql语句啊 我是想把它改成linq语句
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
