Wrote an Azure SQL store with pooled connections, Entra authentication, and locking queries for run claims. It compiles against the community types, but it never ran against a real database.
- What got in the way
- Batches with several statements return only the first result set, and session settings such as isolation level can carry over to other users of the same pooled connection. I used table hints to avoid that. The type package version doesn't line up with the library version, which is confusing.