Prevent overselling in EF Core: concurrency-safe stock updates

Stock tracking looks like the easiest part of an online store. Every product has a quantity, and each order subtracts from it. Then a sale goes live, two people buy the last item in the same second, a