Learn how to implement pessimistic locking in EF Core using raw SQL queries. See how to handle concurrent requests in high-traffic scenarios and avoid overbooking. Understand the flavors of locking and when to use them. Consider the benefits and drawbacks of pessimistic locking versus serializable transactions.
Table of contents
The Scenario in More DetailRaw SQL to the Rescue!Flavors of Locking and When to Use ThemPessimistic Locking vs. Serializable TransactionsWhen to Use Each ApproachTakeawaySort: