Select

var temp = db.Products
                .Where(p => p.ProductID > 0)
                .OrderBy(p => p.ProductID)
                .Skip<Product>(3 * 2)
                .Take<Product>(3)
                .Select(p => new { p.ProductID, p.ProductName }).ToList();

 

SELECT TOP (3)
    [Filter1].[ProductID] AS [ProductID],
    [Filter1].[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].[Products] AS [Extent1]
        WHERE [Extent1].[ProductID] > 0
    )  AS [Filter1]
    WHERE [Filter1].[row_number] > 6
    ORDER BY [Filter1].[ProductID] ASC

 

 

var list = db.Products.ToList();

 

SELECT
    [Extent1].[ProductID] AS [ProductID],
    [Extent1].[ProductName] AS [ProductName],
    [Extent1].[SupplierID] AS [SupplierID],
    [Extent1].[CategoryID] AS [CategoryID],
    [Extent1].[QuantityPerUnit] AS [QuantityPerUnit],
    [Extent1].[UnitPrice] AS [UnitPrice],
    [Extent1].[UnitsInStock] AS [UnitsInStock],
    [Extent1].[UnitsOnOrder] AS [UnitsOnOrder],
    [Extent1].[ReorderLevel] AS [ReorderLevel],
    [Extent1].[Discontinued] AS [Discontinued]
    FROM [dbo].[Products] AS [Extent1]