//1
var ss = (from r indb.Am_recProScheme
where r.rpId > 10
orderby r.rpId descending
selectr).Skip(10).Take(10);
//取第11条到第20条数据跳过前十个取十个
//2 Take(10): 数据从开始获取,获取指定数量(10)的连续数据
var ss1 =db.Am_recProScheme.OrderByDescending(p => p.rpId).Where(p => p.rpId >10).Skip(10).Take(10).ToList();
//3
string sssql = "select *from (select ROW_NUMBER()over(order byrpId desc) as rowNum, * from [Am_recProScheme]) as t where rowNum>10 androwNum<=20";
2.连接查询
//1
var ss = from r in db.Am_recProScheme
join w indb.Am_Test_Result on r.rpId equals w.rsId
orderby r.rpId descending
select r;
//2
var ss1 =db.Am_recProScheme.Join(db.Am_Test_Result, p => p.rpId, r => r.rsId, (p,r) => p).OrderByDescending(p => p.rpId).ToList();
//3
string sssql = "select r.*from [Am_recProScheme] as r inner join[dbo].[Am_Test_Result] as t on r.[rpId] = t.[rsId] order by r.[rpId]desc";