I have developed a Winforms application which handles database requests, with the database lying on a local network server. Therefor I used LINQ to SQL.
Now I read about how to use LINQ's support for optimistic concurrency here. So I simply have to catch the according ChangeConflictExceptionand handle it. I am actually not familiar with databases so I was wondering.
- Is concurrency really completely solved this way.
- What other scenarios should I consider in order to keep my consistent?
Like I said I am new to databases so any kind of advice is welcome.
Thanks in advance