Tag
5 articles
'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.
