Deep dive into managing DbContext / IDbConnection Scopes in DI.

Database contexts must be strictly managed to prevent connection exhaustion and cross-thread data corruption.

In web applications, DbContext should always be Scoped. This ensures all repositories in a single HTTP request share the same transaction and caching layer. In background workers (Singletons), you must manually create Scopes to resolve transient database connections, otherwise the connection stays open indefinitely.