Although Microsoft SQL Server Compact 3.5 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.
In This Section
Topic |
Description |
|---|---|
Describes deadlocks, which can occur when two connections have blocked each other. |
|
Describes lock time-outs. |
|
Describes transaction isolation levels. |
|
Describes the locking hints you can use in SQL Server Compact 3.5. |