???????OFFSET FETCH?????
???????LINQ?????????????????SQLServer????????????????????????????????械??????SQL Server Compact 4.0???????OFFSET FETCH???
????SELECT  *
????FROM    dbo.Products
????ORDER   BY UnitPrice DESC
????OFFSET  ( @pageSize * ( @pageIndex - 1 )) ROWS
????FETCH NEXT @pageSize ROWS ONLY;
??????????LINQ????OFFSEET????SKIP??FETCH NEXT????TAKE??
???????????????????SQL Server CE 4.0?????????SQL Server 2012??SQL Server 2014?????????????Microsoft Webmatrix???????????????1????
???????
????????????????????????????????????????写SQL??????????????????????蔚?????????谐????????????????*????????胁?????????????????????????????????????????????????????????????????????????????效?????????SQL?械????????????????????????????B???????校?????????????????写?????械????锟�?????????????SQL Server ???些???????CTE??IN ??Exist???????????些小???????????????????????
????????????些?????????????????????????????????????谩?
????????Top – Not In - Top????????????????????in???效???????????????姹�??SQL Server??
????????ROW_Number????????????????校?效?????LINQ?械?SKIP??TAKE?????????????????蟹?????????????????????????????
????FFSET FETCH ??????SQL Server CE 4.0 ?胁?????????????????SQL Server 2012??????????????comparing-performance-for-different-sql-server-paging-methods??????????????????Sql Server 2012 ???????????(offset and fetch)????????????????
???????????SQLServer?????SQL????????????????????????????