Entity framework and pessimistic concurrency

Entity framework supports optimistic concurrency out of the box but using pessimistic concurrency requires manual implementation. This article explains why simple solutions don't work and provides a working solution.