DataContext Developer access

Hi,

Does anyone know of a safe way to expose the DataContext without having to make changes to the BaseDataProvider in order to take advantage of the Linq2DB Merge statement?

The idea would be to Bulk Insert new Products/Categories from an API, then use a Merge Statement to make updates or insert new Products. The current process of looping through records and updating/inserting records one by one if incredibly inefficient and resource intensive.

Please advise.

The 'inefficiency' is due to the complexity: validation, default values, children/multiples (e.g. categories,  manufacturers, tags), creating URL slugs, store and vendor limitations, images, etc.

While I fully understand this, I want to build something that performs the updates/inserts in batches instead of one by one since this is currently causing massive CPU spikes which can cause the hosted instance to perform very poorly from an end user pespective. When you are running a eCommerce site on a Quad Core Xeon CPU, with 32GB ram and nothing else on the server, it becomes concerning.