Dynamics 365 for Finance and Operations Development Cookbook - Fourth Edition

How it works...

The RecordInsertList class acts as an array of the given type and holds the table buffer. It can insert multiple records in a single database trip. The add() method prepares the stack of records and the insertDatabase() method packs these records and sends them to the database in a single trip, where they are unpacked and inserted into the database table record by record. While creating an instance of RecordInsertList, we could skip certain system methods, such as insert by passing some parameters.

We have also used insert_recordSet/delete_from/update_recordSet, which are called set based operations, and insert all records in a database in a single call to the database. However, these operations are converted to record-by-record ...