Implements batching upsert functionality in SQL Server Memory DB to enhance performance for bulk data operations.
Introduces the IMemoryDbBatchUpsert interface and implements it in SqlServerMemory.cs, enabling batch upsert capabilities.
Adds a new method BatchUpsertAsync for handling batch upsert operations efficiently.
Modifies the UpsertAsync method to internally call BatchUpsertAsync for single record upserts, ensuring consistency in upsert operations.
Updates the README.md in the SQLServer extension to include documentation and examples on using the new batch upsert feature, guiding users on how to leverage this functionality for improved performance.
Related to #485
Implements batching upsert functionality in SQL Server Memory DB to enhance performance for bulk data operations.
IMemoryDbBatchUpsertinterface and implements it inSqlServerMemory.cs, enabling batch upsert capabilities.BatchUpsertAsyncfor handling batch upsert operations efficiently.UpsertAsyncmethod to internally callBatchUpsertAsyncfor single record upserts, ensuring consistency in upsert operations.README.mdin the SQLServer extension to include documentation and examples on using the new batch upsert feature, guiding users on how to leverage this functionality for improved performance.For more details, open the Copilot Workspace session.