linq的知识

-分页数据查询:

     //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";