Designing a ledger: balances should be derived from transactions
A balance column tells you a number. A ledger tells you why. How to make recorded transactions the single source of truth for a wallet, with runnable EF Core code.
#sql-server
EF Core or Dapper? A deliberate split instead of one ORM everywhere
Use EF Core where you change data and Dapper where you read it for a screen or a report. Here is why the split works, with runnable code that shares one connection.
Optimistic vs pessimistic concurrency in EF Core, explained with a wallet balance
Two withdrawals read the same balance and both succeed: that's a race condition. Three ways to stop it in EF Core (rowversion, an atomic update, and a row lock) and when to use each.