LINQ series: LINQ to SQL Take/skip

1. Take

var expr = context. Products    . Take (ten);

var expr = ( from in context. Products            select  p)            . Take (ten);

SELECT TOP(Ten)     [C].[ProductID]  as [ProductID],     [C].[CategoryID]  as [CategoryID],     [C].[ProductName]  as [ProductName],     [C].[UnitPrice]  as [UnitPrice],     [C].[UnitsInStock]  as [UnitsInStock],     [C].[discontinued]  as [discontinued]     from [dbo].[Product]  as [C]

2. Skip

　　Before you can use the Skip method, you need to sort by order first.

var expr = context. Products    new  {p.productid, p.productname})    = p.productid)    . Skip (ten);

SELECT     [Extent1].[ProductID]  as [ProductID],     [Extent1].[ProductName]  as [ProductName]     from(SELECT [Extent1].[ProductID]  as [ProductID],[Extent1].[ProductName]  as [ProductName], Row_number () Over(ORDER  by [Extent1].[ProductID] ASC) as [Row_number]         from [dbo].[Product]  as [Extent1]    )   as [Extent1]    WHERE [Extent1].[Row_number] > Ten    ORDER  by [Extent1].[ProductID] ASC

3. Paging Query Take/skip

var expr = context. Products    new  {p.productid, p.productname})    = p.productid)    . Skip (ten)    . Take (ten);

SELECT TOP(Ten)     [Extent1].[ProductID]  as [ProductID],     [Extent1].[ProductName]  as [ProductName]     from(SELECT [Extent1].[ProductID]  as [ProductID],[Extent1].[ProductName]  as [ProductName], Row_number () Over(ORDER  by [Extent1].[ProductID] ASC) as [Row_number]         from [dbo].[Product]  as [Extent1]    )   as [Extent1]    WHERE [Extent1].[Row_number] > Ten    ORDER  by [Extent1].[ProductID] ASC

LINQ series: LINQ to SQL Take/skip