我希望这个查询将linq转换为sql [英] I want this query convert linq to sql
本文介绍了我希望这个查询将linq转换为sql的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好我想将此linq查询转换为sql
int take = 10 ,pageSize = 10
var jobsdata = 来自 n context.Jobs.OrderByDescending(o = > o.Id).Take(take).Skip(pageSize) select n;
请帮帮我......
谢谢....
解决方案
with x as(SELECT ROW_NUMBER()over(order by Id asc)as row,* from Jobs where id ='1'
) select * from x where(1)和(@take)之间的行
从LINQ获取TSQL查询DataContext.SubmitChanges()
实际上有一个非常简单回答你的问题
只需将它粘贴在你的手表窗口即可w $>
((System.Data.Objects.ObjectQuery)myLinqQueryVar)。ToTraceString()
Hi I want convert this linq query into sql
int take=10, pageSize=10
var jobsdata = from n in context.Jobs.OrderByDescending(o => o.Id).Take(take).Skip(pageSize) select n;
Please help me......
Thank you....
解决方案
with x as (SELECT ROW_NUMBER() over(order by Id asc ) as row ,* from Jobs where id='1'
)select * from x where row between (1) and (@take)
Get the TSQL Query from LINQ DataContext.SubmitChanges()
There is actually a very simple answer to your question
Just paste this in your watch window
((System.Data.Objects.ObjectQuery)myLinqQueryVar).ToTraceString()
这篇关于我希望这个查询将linq转换为sql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文