Microsoft Visual Studio 2008 Service Pack 1 (SP1) is the preferred environment for developing smart device applications for Microsoft SQL Server Compact 3.5. Microsoft Visual Studio 2010 does not provide support for developing smart device applications. If Visual Studio 2010 is not installed on your development computer, however, you may need to upgrade to SQL Server Compact 3.5 Service Pack 2 (SP2). For more information, see Installing and Deploying on a Desktop (SQL Server Compact). SQL Server Compact is installed automatically on the smart device when deploying a managed application created in Visual Studio 2008 SP1. If you create a native application in Visual Studio 2008 SP1 by using Visual C++, you must manually copy the files that install SQL Server Compact on the smart device. For information about 64-bit deployments, see Managing 64-bit Database Applications.
Visual Studio 2008 SP1 is the preferred environment for developing smart device applications for SQL Server Compact 3.5. Visual Studio 2010 does not provide support for developing smart device applications. For more information, see Installing a Development Environment. |
Installing SQL Server Compact 3.5 When Deploying a Managed Application
When you build a managed application that references the System.Data.SqlServerCe namespace, and the application is deployed to a smart device or the Pocket PC emulator, Visual Studio automatically checks to see whether the device has the Microsoft .NET Compact Framework and SQL Server Compact client components installed. If these components are not detected, they are automatically installed on the device the first time that you deploy an application that references the System.Data.SqlServerCe namespace. The default installation location for the SQL Server Compact 3.5 client components on the device is %Program Files%\Microsoft SQL Server Compact Edition\v3.5.
To deploy an application to a smart device, click Start Debugging on the Debug menu in Visual Studio. Then, choose whether to deploy to a connected smart device or to the Pocket PC emulator.
Installing SQL Server Compact 3.5 When Deploying a Native Application
SQL Server Compact 3.5 and SQL Server Compact 3.5 Query Analyzer are installed automatically if you are using Visual Studio 2008 SP1 with a smart device project. They require manual installation if you are developing a native application by using Visual C++.
You must manually copy SQL Server Compact 3.5 and SQL Server Compact 3.5 Query Analyzer to the device by copying and extracting the following .cab files from %ProgramFiles%\Microsoft SQL Server Compact Edition\v3.5\Devices\platform\processor\ to the root directory of the device:
sqlce.device_type.platform.processor.CAB
sqlce.dev.language.device_type.platform.processor.CAB
sqlce.repl.device_type.platform.processor.CAB
A shortcut to SQL Server Compact 3.5 Query Analyzer appears on the Start menu of the device.
To start SQL Server Compact 3.5 Query Analyzer, either click the application name on the Start menu or tap the icon on the device.
Tasks
How to: Install Query Analyzer (SQL Server Compact)
How to: Install SQL Server Compact on a Device
Concepts
Installing a Development Environment