Home | The Bedroom Coder

C# •05-Jun-2026

Handling Soft Deletes in EF Core

When working with business applications, permanently deleting data is often undesirable. Records may need to be restored, audited or retained for compliance purposes. Soft deletes provide a simple solution by marking records as deleted rather than removing them from the database. In this article, we'll explore how to implement soft deletes in Entity Framework Core using query filters and save interception techniques.

Read more 5 min read

C# •02-Jun-2026

Tracking vs No-Tracking Queries Explained

When working with Entity Framework, one of the most overlooked performance considerations is whether queries should be tracked or not. By default, Entity Framework tracks entities returned from queries, allowing changes to be detected and saved automatically. However, tracking comes with overhead and is not always necessary. Understanding when to use tracking and no-tracking queries can improve application performance and reduce memory usage.

Read more 5 min read

SQL •31-May-2026

Writing Raw SQL When Entity Framework Isn’t Enough

Entity Framework makes database access straightforward, handling most queries with minimal code. However, there are situations where LINQ queries become difficult to optimise, database-specific features are required, or performance is critical. In these cases, writing raw SQL can provide greater control, improved efficiency, and access to capabilities that Entity Framework does not directly support.

Migrations in EF Core Without Breaking Production

Entity Framework Core migrations make database changes manageable, but applying them incorrectly can cause downtime, failed deployments, or data loss in production. This article explores practical strategies for safely managing EF Core migrations, including deployment planning, testing, rollback preparation, and handling schema changes in live environments without disrupting users.

SQL Queries Every Developer Should Know

Whether you are building web applications, desktop software, or APIs, a solid understanding of SQL is essential. While ORMs can simplify database access, every developer benefits from knowing how to write efficient SQL queries. This article explores some of the most useful SQL queries and techniques that can help you retrieve, analyse, and manage data more effectively.

Read more 5 min read

SQL •19-May-2026

Indexes Explained Like It’s 1988

Back in 1988, computers were slower, hard drives were noisy, and every second counted. Database indexes were the secret weapon that helped systems find information quickly without searching every single record one by one. Even though technology has changed dramatically since then, indexes still work on the same core idea today. This article explains database indexes using retro computing comparisons anyone can understand.

Read more 5 min read

From Amstrad to Amiga to Blazor and Beyond

Latest Posts

Handling Soft Deletes in EF Core

Tracking vs No-Tracking Queries Explained

Writing Raw SQL When Entity Framework Isn’t Enough

Migrations in EF Core Without Breaking Production

SQL Queries Every Developer Should Know

Indexes Explained Like It’s 1988