Dynamics 365 for Finance and Operations Development Cookbook - Fourth Edition

Using update_recordSet for faster updates

Sometimes, we need to update some records in a table, which we might do using loops, which can be time consuming. Here, to update the records in a single application to database trip, we can use update_recordSet. Create an updateInvoicesUpdateRecordSet class and add the following code:

 class updateInvoicesUpdateRecordSet { /// <summary> /// Runs the class with the specified arguments. /// </summary> /// <param name = "_args">The specified arguments.</param> public static void main(Args _args) { PacktCustomerInvoices customerInvoice; int64 timeTaken; System.DateTime dateTimeNow; System.TimeSpan timeSpan; utcdatetime startDateTimeUTC; int64 i; select count(RecId) from customerInvoice where customerInvoice.InvoiceQty<100;; ...