Customizing Locking

Customizing Locking

Although Microsoft SQL Server Compact 4.0 implements locking automatically, it is possible to customize locking in applications by:

  • Handling deadlocks.

  • Setting the lock time-out duration.

  • Setting the transaction isolation level.

  • Using table-level locking hints with the SELECT, INSERT, UPDATE, and DELETE statements.




Describes deadlocks, which can occur when two connections have blocked each other.

Lock Time-out

Describes lock time-outs.

Transaction Isolation Level

Describes transaction isolation levels.

Locking Hints

Describes the locking hints you can use in SQL Server Compact 4.0.

© 2016 Microsoft