When you work any database, you constantly access and manipulate data in the tables for querying purposes. You also modify that data to suit your needs. Before you make changes to a Microsoft SQL Server Compact 3.5 database, you should understand the complex concepts that facilitate data modifications.
Describes how locking allows multiple users to access the same data concurrently in a SQL Server Compact 3.5 database.
Describes how multiple users can access data simultaneously without any conflicts.
Describes how transactions are supported, and how they can be accessed programmatically.
Describes how the isolation levels work with locking to ensure that users can access data concurrently.
Describes the different locking mechanisms that allow multiple users to access data concurrently.
Describes the cursor support available in SQL Server Compact 3.5.