You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
BulkOperations<TEntity> is documented as supporting batched INSERT for non-SQL Server providers, but the implementation directly imports Microsoft.Data.SqlClient and uses SqlBulkCopy for SQL Server.
File: DBTools/Bulk/BulkOperations.cs
Non-SQL Server bulk paths may be incomplete or untested.
Proposed solution
Abstract bulk insert behind IDbProvider or a dedicated IBulkInsert interface
Keep SqlBulkCopy as SQL Server optimization only
Implement/test batched INSERT fallback for PostgreSQL, MySQL, SQLite
Problem
BulkOperations<TEntity>is documented as supporting batched INSERT for non-SQL Server providers, but the implementation directly importsMicrosoft.Data.SqlClientand usesSqlBulkCopyfor SQL Server.File:
DBTools/Bulk/BulkOperations.csNon-SQL Server bulk paths may be incomplete or untested.
Proposed solution
IDbProvideror a dedicatedIBulkInsertinterfaceSqlBulkCopyas SQL Server optimization onlyAcceptance criteria
SqlConnection/SqlBulkCopyusage outside SQL Server code pathRelated
#28 (tests), #32 (multi-provider migration)