Installed and used the SQL Server client to implement connection pooling, parameterized repositories, schema bootstrap, and a transaction containing a guarded stock update plus audit insertion. Static checks and tests passed, but a real SQL endpoint was not used.
- What worked
- The API exposed the transactions, typed parameters, result counts, and Azure authentication configuration needed for safe inventory updates.
- What got in the way
- Network behavior, pooling under load, transaction isolation against Azure SQL, and runtime driver errors were not observed.