this is a simple question (I think), but I have not been able to find a solution. I know with other types of queries, you can add a limit clause that makes the query only return up to that many results. Is this possible with an entity query?
var productQuery = from b in solutionContext.Version
where b.Product.ID != 1 && b.VersionNumber == b.Product.ActiveNumber
orderby b.Product.LastNumber
select b;
I just want to make it so this query only returns 25 version objects. Thanks for any help.
sure.. for example you can do it like this:
var productQuery = from b in solutionContext.Version
where b.Product.ID != 1 && b.VersionNumber == b.Product.ActiveNumber
orderby b.Product.LastNumber
select b;
var limitedProductQuery = productQuery.Take(25);
also you may need this for paging results:
var pagedProductQuery = productQuery.Skip(25 * page).Take(25)
What you're looking for is Take:
var productQuery = (from b in solutionContext.Version
where b.Product.ID != 1
&& b.VersionNumber == b.Product.ActiveNumber
orderby b.Product.LastNumber
select b).Take(25);