Question

how many types of solutions of lost update problem​

Answer 1

Answer:

So to resolve lost updates in DB layer SNAP SHOT isolation level must be used. If READ_COMMITTED or READ_COMMITTED_SNAP SHOT is used, then Lost update problem must be solved in application layer. Here is how it is done Row versioning in Entity framework.