1 bug fixed
The bug log.
Real fixes, each with the symptom, the root cause, the change and the result.
#001 · September 2025 · .NET 8, SQL Server, TransactionScope, Microsoft.Data.SqlClient
TransactionScope Failure in Production – System.Data.SqlClient to Microsoft.Data.SqlClient Migration
- Symptom
- Database transactions using TransactionScope worked as expected in the UAT environment but failed after deployment to production.
- Root cause
- The application was using the legacy System.Data.SqlClient provider. A compatibility issue with the production environment's transaction handling was identified as the cause.
- Fix
- Migrated the SQL Server data provider from System.Data.SqlClient to Microsoft.Data.SqlClient and updated the relevant dependencies and references.
TransactionScope operations worked successfully in the production environment after the provider migration.