This topic has not yet been rated - Rate this topic

Understanding Locking

Microsoft SQL Server Compact supports multigranular locking that permits different types of resources to be locked by a transaction.

Automatic Locking

SQL Server Compact automatically locks the required data to protect all the operations of a transaction, including:

Data manipulation language (DML)
Data definition language (DDL)
Query statements at the required isolation level

SQL Server Compact automatically locks rows of data, and any relevant index pages, to ensure maximum concurrency. As a transaction locks more resources, the granularity of the lock automatically increases to an entire table so that lock maintenance is reduced.

In This Section

Topic	Description
Basics of Locking	Describes the basics.
Lock Escalation	Describes the process of converting many fine-grain locks into fewer coarse-grain locks.
Lock Compatibility	Describes the process of determining lock compatibility.

Concepts

Locking (SQL Server Compact)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)