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]
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步