1. create a DB column with timestamp data type - say rowversion
  2. for each insert and update operation performed on a table, check rowversion’s current value with fetched value, during update change value for rowversion column
  3. set Concurrency Mode to Fixed by right clicking on the rowversion property of the entity