October 25, 2026
Keep CQRS Use Cases Clear Without Splitting the Application
Separate commands from queries while keeping one deployable application and one transactional database.
TOPIC
Interview Practice
Scenario-based questions for interview preparation.
October 25, 2026
Protect Cookie-Based Internal APIs from CSRF
Authentication identifies a signed-in administrator; authorization and anti-forgery checks protect each mutation.
October 25, 2026
Choose ASP.NET Core Dependency Lifetimes by Ownership
Understand scoped request services, singleton lifetime, and the captive dependency problem.
October 25, 2026
Choose Offset or Keyset Pagination with Evidence
Offset paging is convenient; keyset paging can keep deep sequential pages efficient and stable.
October 25, 2026
Make PostgreSQL Upserts Safe and Idempotent
Use a unique key, ON CONFLICT, and a transaction boundary that matches the business operation.
October 25, 2026
Use SQL Window Functions for Rankings and Trends
Rank rows within groups and calculate running metrics without collapsing detail rows.
October 25, 2026
Value Semantics, References, and Records in C#
Understand copying, mutation, equality, and when an immutable record makes a clearer data contract.
October 25, 2026
Async Request Flows Need Cancellation
Propagate request cancellation through database and network calls, and keep async APIs honest about failures.
October 25, 2026
Shape EF Core Queries Around the Response
Use projection, bounded results, and deliberate loading to avoid oversized queries and N+1 behavior.