Thank you for the provided additional information.
I have implemented your exact case and executed it. Here is the code I used:
Could you tell me how you have displayed this "CommandText" property?
var query = context.GetAll<Product>().Where(p => p.Name.StartsWith(name)).Take(10);
When I want to check what SQL query will be created from that specific code I execute this:
The end result was:
"SELECT TOP(??T) a.[Products_id] AS COL1, a.[CategoryId] AS COL2, a.[CreatedBy] AS COL3, a.[CreatedDate] AS COL4, a.[Discontinued] AS COL5, a.[Id] AS COL6, a.[nme] AS COL7, a.[Price] AS COL8 FROM [Products] a WHERE a.[nme] LIKE ? + '%' ESCAPE '\\' "
As you may see in the generated SQL query, there is a TOP parameter. Also the query, when executed, actually retrieved the first 10 records.
When you execute the query on your side, is an actual paging enforced?
Are the first 10 records retrieved or all of them?
Thank you in advance.
Check out the latest announcement
about Telerik Data Access vNext as a powerful framework
able to solve core development problems.