I'm designing a web application where different users could be updating the same records.
I would like to make sure that only the changed fields by one user are updated one by one so there is no concurrency violation.
What is the best method to design this?
Its my first time working with SQL 2005 so i'm not sure about the tableAdapters "optimistic concurrency" option. Will this take care of it by itself?