BulkMerge upserts thousands of entity records in a single call. It creates new records, updates the ones that changed, and can delete rows that aren’t in the list, all inside the request’s transaction.

• Any entity: pass an entity list, or an aggregate’s list of a single entity, converted with ToObject(). Your own entities and extension entities both work.
• Skips identical records: records that haven’t changed aren’t written at all. You can also list attributes to ignore in the comparison, such as ModifiedOn or ModifiedBy.
• Full results: it returns the created records with their new IDs, the updated records along with how they looked before the update, and the deleted rows. Each comes with its own count, and lists follow the order of your input. Turn the lists off when you only need the counts and save performance.
• Optional delete: remove every row whose ID isn’t in the list, so the table matches your list exactly.
• Works with: SQL Server, Azure SQL, Oracle 12.1.0.2+, PostgreSQL and MySQL, including external databases through a Service Center database connection.
• Built for volume: tested with 300,000 records.