Using SQL Server Compact (Visual Studio)

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.