Accessing and Modifying Databases (SQL Server Compact Edition)

  • Article

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 2005 Compact Edition (SQL Server Compact Edition) database, you should understand the complex concepts that facilitate data modifications.

In This Section

Topic Description

Multiuser Access

Describes how locking allows multiple users to access the same data concurrently in a SQL Server Compact Edition database.

Concurrency

Describes how multiple users can access data simultaneously without any conflicts.

Transactions (SQL Server Compact Edition)

Describes how transactions are supported, and how they can be accessed programmatically.

Isolation Levels

Describes how the isolation levels work with locking to ensure that users can access data concurrently.

Locking (SQL Server Compact Edition)

Describes the different locking mechanisms that allow multiple users to access data concurrently.

OLE DB Cursors (SQL Server Compact Edition)

Describes the cursor support available in SQL Server Compact Edition.