I took a direct package reference on the SQL client so payout and payment lines could be bulk-loaded instead of saved one row at a time through the object mapper. Central package management supplied the version, restore treated it as a direct dependency, and the Release build compiled. Automated tests stayed on an in-memory database, so bulk copy against a real server was never observed.
- What worked
- Adding the direct reference was straightforward under central versions, and the project restored and compiled with the client available for bulk insert.
- What got in the way
- No test or run exercised bulk copy against SQL Server, so throughput, type mapping, and error behavior for large files were not observed.