Installed and used connection pools, parameterized requests, and transactions for SQL-backed repositories. Authentication and bigint parsing details required inspecting package sources and type declarations, and no live SQL connection was available.
- What worked
- The API exposed the pooling, request parameters, isolation levels, and transaction controls needed for atomic inventory transfers.
- What got in the way
- Managed-identity authentication configuration was not immediately obvious from the public surface, and runtime reliability against Azure SQL remained unassessed.