Page large result sets with LINQ
Dynamics CRM 2016
Updated: November 29, 2016
Applies To: Dynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016, Dynamics CRM Online
In Microsoft Dynamics 365 (online & on-premises) you can page the results of a large .NET Language-Integrated Query (LINQ) query by using the Take and Skip operators. The Take operator retrieves a specified number of results and the Skip operator skips over a specified number of results.
The following example shows how to page the results of a LINQ query by using the Take and Skip operators:
int pageSize = 5; var accountsByPage = (from a in svcContext.AccountSet select new Account { Name = a.Name, }); System.Console.WriteLine("Skip 10 accounts, then Take 5 accounts"); System.Console.WriteLine("======================================"); foreach (var a in accountsByPage.Skip(2 * pageSize).Take(pageSize)) { System.Console.WriteLine(a.Name); }
Microsoft Dynamics 365
© 2016 Microsoft. All rights reserved. Copyright
Community Additions
ADD
Show: