Dynamics 365 for Finance and Operations Development Cookbook - Fourth Edition

Using delete_from

We might need to delete records from a table specifying some clause in minimum time. This we could achieve using delete_from. Create a deleteInvoicesDeleteFrom class and add the following code:

 class deleteInvoicesDeleteFrom { /// <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; i = customerInvoice.RecId; startDateTimeUTC = DateTimeUtil::utcNow(); //deletes all record in one go. delete_from customerInvoice; dateTimeNow ...