This topic has not yet been rated - Rate this topic

Using SQL Server Compact (Visual Studio)

Visual Studio 2012

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

Microsoft SQL Server Compact is the preferred local database for client applications. This section describes the basic tasks for incorporating SQL Server Compact databases into client applications. For detailed information about SQL Server Compact, see SQL Server Compact Books Online.

Note
To download SQL Server Compact 4.0 Books Online, go to the SQL Server Compact 4.0 Books Online Download Center.

In This Section

SQL Server Compact 4.0 and Visual Studio: Provides an introduction to SQL Server Compact.
How to: Add a SQL Server Compact Database to a Project: Describes how to add a new or existing SQL Server Compact database to a Windows-based application.
How to: Deploy a SQL Server Compact 4.0 Database with an Application: Describes how to configure deployment for a Windows-based application that includes a SQL Server Compact database.
Walkthrough: Creating a SQL Server Compact Database: Provides step-by-step details for creating a SQL Server Compact database that has two tables with a relationship between them.
Walkthrough: Adding a SQL Server Compact Database to an Application and Deploying it: Provides step-by-step details for incorporating a SQL Server Compact database in a Windows-based application and configuring the application for deployment.

Related Sections

Local Data Overview: Describes the Visual Studio features for incorporating database files directly into an application.
Occasionally Connected Applications (Local Database Caching): Provides a list of topics about creating applications that use a SQL Server Compact database to locally cache data from a remote database.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)