Using SQL Server Compact 3.5 (Visual Studio)

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

Note

To download SQL Server Compact 3.5 Books Online, go to the Microsoft Download Center Web site.

In This Section

• SQL Server Compact 3.5 and Visual Studio
  Provides an introduction to SQL Server Compact 3.5.

• How to: Add a SQL Server Compact 3.5 Database to a Project
  Describes how to add a new or existing SQL Server Compact 3.5 database to a Windows-based application.

• How to: Deploy a SQL Server Compact 3.5 Database with an Application
  Describes how to configure deployment for a Windows-based application that includes a SQL Server Compact 3.5 database.

• Walkthrough: Creating a SQL Server Compact 3.5 Database
  Provides step-by-step details for creating a SQL Server Compact 3.5 database that has two tables with a relationship between them.

• Walkthrough: Adding a SQL Server Compact 3.5 Database to an Application and Deploying it
  Provides step-by-step details for incorporating a SQL Server Compact 3.5 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
  Provides a list of topics about creating applications that use a SQL Server Compact 3.5 database to locally cache data from a remote database.

• SQL Server Compact 3.5 and LINQ to SQL
  Describes how SQL Server Compact 3.5 differs from SQL Server in LINQ to SQL applications.

• Using SQL Server Compact 3.5 Databases (Devices)
  Provides information about how to manage data by using SQL Server Compact 3.5, either as a remote client or with a database on the device.

• SQL Server Compact 3.5 Books Online Download Center
  The site to download SQL Server Compact 3.5 documentation.