Ado. Net concurrency

Source: Internet
Author: User

1. Live later
Only the primary key is included in the where condition for update and deletion. For example:
User A reads a row
User B reads the same row
User B modifies this line and successfully submits changes
User a modified this line and successfully submitted the changes, covering the changes just submitted by user B.

2. Full field comparison
The where condition for update and deletion includes all fields, which can prevent future occupation. BLOB fields cannot be compared.

3. The where conditions for update and deletion include primary key and timestamp columns (timestamp columns must be added to the Table). The same as 2, the where condition can be simplified.

4. When primary keys and columns to be updated are used, different users can update different columns at the same time without overwriting each other.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.