llblgen Pro SELECT TOP(n)等效查询 [英] llblgen Pro SELECT TOP (n) equivalent query

问题描述

是否可以在llblgen pro中执行选择顶部(n)查询?...不是LINQ.如果是这样，我该如何使用SelfServicing做到这一点?

Is it possible to perform a select top (n) query in llblgen pro?...not LINQ. If so, how can I achieve that using the SelfServicing?

推荐答案

只需使用接受maxItemsToReturn参数的GelMulti重载即可:

Just use the GelMulti overloads that accepts the maxItemsToReturn parameter:

int itemsToReturn = 10;    
OrderCollection orders = new OrderCollection();
orders.GetMulti(null, itemsToReturn);

这是生成的SQL:

SELECT TOP(@p2) [Northwind].[dbo].[Orders].[CustomerID] AS [CustomerId], ... 
FROM [Northwind].[dbo].[Orders]  
Parameter: @p2 : Int64. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 10.

这篇关于llblgen Pro SELECT TOP(n)等效查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！