Tag
8 articles
This site's old MVC app used Hangfire with its own database. The API that replaced it uses two BackgroundService workers and a bounded Channel. Here is what each job became, the code, and what I gave up.
'Error unprotecting the session cookie' in ASP.NET Core means the Data Protection keys were lost. What I reproduced, the different messages each cause produces, and the Program.cs fix for IIS.
'UPDATE failed because the following SET options have incorrect settings: QUOTED_IDENTIFIER' - why the same statement works from your app and fails from sqlcmd, what I tested on SQL Server 2022, and the one-line fixes for scripts, sqlcmd and stored procedures.
Three different SQL Server errors, one root cause: your migration files and the __EFMigrationsHistory table disagree about what has been applied. Here is the query that shows you the disagreement, and the fix for each of the three ways it happens.
An index is how reads survive scale; idempotency is how writes survive retries. What each one fixes, why composite column order decides everything, why an idempotency key needs a UNIQUE constraint, and the migration-history failure where both ideas meet.
Move an ASP.NET MVC app to React or Next.js without forking the database or freezing the old site: the shared data layer, the EF migration trap, and the IIS deploy that silently does nothing.
EF Core projections, tagged output caching and batched writes - the seven changes that made a real Web API fast on a slow database link.
ASP.NET Core runs on Linux, and so does SQL Server. Here is how to tell which .NET you are on, and how much RAM and storage each option really needs.
