Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Accessing and Modifying Databases (SQL Server Compact)

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

Topic Description

Multiuser Access

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

Concurrency

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

Transactions (SQL Server Compact)

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)

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

OLE DB Cursors (SQL Server Compact)

Describes the cursor support available in SQL Server Compact 3.5.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.