I have a work order counter stored in an oracle database. When someone adds a new work order, this number is retrieved from the database and incremented by one and stored back. There is a one or two second delay before anyone else on the network sees the change. If someone else adds another workorder during this time, they get the same number. They get duplicate work order numbers. How can these be avoided?
BTW, I am using DBISaveChanges to flush any cache.