SQL Server compact 3.5 Development Environment Description

ArticleDirectory

• Clickonce deployment for deploying hosted applications

You can use the Microsoft Visual Studio development environment to develop SQL Server compact 3.5 applications.Program. Visual Studio is the easiest way to develop and deploy applications that use SQL Server compact 3.5. In Visual Studio, you can use Visual C # Or Visual Basic to create a hosted application. You can also create local applications for desktops and devices by using the Visual C ++ option (formerly known as Microsoft Embedded Visual C ++ 4.0. Visual Studio 2008 and later versions support visual c ++.

Note:
SQL Server compact 3.5 or later does not support Microsoft Embedded Visual Basic.

You can use Visual Studio 2008 and later to develop SQL Server compact 3.5 applications. However

• Visual Studio 2010 is the preferred environment for developing desktop applications. This is because Visual Studio 2010 supports new development functions, such as using the transact-SQL editor on the SQL Server compact database. You can use Visual Studio 2008 or Visual Studio 2008 Service Pack 1 (SP1) to develop SQL Server compact 3.5 desktop applications, but cannot use the new development functions provided in Visual Studio 2010.

• Visual Studio 2008 Service Pack 1 (SP1) is the preferred environment for developing Device Applications. This is because Visual Studio 2010 does not support the development of smart device applications.

Visual Studio 2010 and Visual Studio 2008 SP1 can be installed on the same computer and run concurrently.

Visual Studio file location and description

The following table lists the SQL Server compact 2008 files installed on the development computer when you use Visual Studio 2010 or Visual Studio 3.5 by location. By default, these files and folders are created in the following locations:

• For Visual Studio 2008, it is % ProgramFiles % \ Microsoft Visual Studio 9.0.

• For Visual Studio 2010, it is % ProgramFiles % \ Microsoft Visual Studio 10.0.

• For SQL Server compact 3.5, the value is % ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \.

Location	Content
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5	SQL Server compact 3.5 DLL for desktops: sqlcecompact35.dll, sqlceca35.dll, sqlceme35.dll, sqlceoledb35.dll, sqlceqp35.dll, and sqlcese35.dll. The error message is that the DLL (sqlceer35 . dll) is also installed in this folder. The DLL for different languages contains a suffix of two letters used to indicate the language, such as en and Fr. This folder also contains the README file, license terms, and redist _ . txt. In addition, this folder contains the managed provider for SQL Server compact 3.5 Entity Framework: system. Data. sqlserverce. entity. dll. This is the version installed in the Global Assembly Cache (GAC. This version of the Entity Framework provider is used when you generate a desktop application that centrally deploys SQL Server compact or when generating a device application. Starting from SQL Server compact 3.5 SP2, for desktop applications that deploy SQL Server compact in a dedicated manner, use the provider version in % ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ private.
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ Desktop	The SQL Server compact 3.5 hosting provider for desktops: system. Data. sqlserverce. dll. Starting from SQL Server compact 3.5 SP2, this folder contains the managed provider version to be used to generate desktop applications that use centrally deployed SQL Server compact. This is the version installed in GAC. Starting from SQL Server compact 3.5 SP2, for desktop applications that deploy SQL Server compact in a dedicated manner, use the provider version in % ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ private.
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ private	The SQL Server compact 3.5 hosting provider system. Data. sqlserverce. DLL for desktops, and the managed provider system. Data. sqlserverce. entity. DLL for SQL Server compact 3.5 Entity Framework. This folder is introduced with SQL Server compact 3.5 SP2. This includes the managed provider version used to generate a desktop application that uses the dedicated deployment SQL Server compact.
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ Devices	The SQL Server compact 3.5 hosting provider for the device: system. Data. sqlserverce. dll. This folder contains the managed provider version to be used when generating the device application. This version of the hosting provider is used for both centralized deployment and dedicated deployment of SQL Server compact on the device.
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ sync \ SQL	SQL Server compact 3.5 server tool DLL used to copy data between SQL Server and SQL Server compact 3.5: sqlcesa35.dll, sqlcerp35.dll, and connwiz.exe. This folder also contains a file containing the SQL Server compact 3.5 server tool license terms.
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ <Lang>	Localized resources for hosting providers: system. Data. sqlserverce. Resources. dll
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ devices \ platform \ processor	A series of subfolders. Each folder contains: sqlce. platform. processor. cab sqlce. platform. processor. the cab file contains sqlcese35.dll, sqlceqp35.dll, sqlceme35.dll, and system. data. sqlserverce. DLL. sqlce. REPL. Platform. processor. Cab sqlce. REPL. Platform. processor. Cab contains sqlceca35.dll, sqlceoledb35.dll, and sqlcecompact35.dll. sqlce. dev. lang. platform. processor. cab sqlce. dev. lang. platform. processor. the cab file contains isqlw35.exe (a program that implements SQL Server compact 3.5 query analyzer) and sqlceerr35lang. DLL ).
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ devices \ Client	System. Data. sqlclient. dll is used to directly connect to SQL Server from a mobile device without using SQL Server compact 3.5. The cab file used to deploy SQL Server compact 3.5 on mobile devices is SQL. [platform]. [processor]. Cab and SQL. Dev. [platform]. [processor]. Cab. The two cab files can be found under % ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ devicesplatform \ processor. Note:Folder % ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ devices \ wce500 CAB files and DLL files are also used to install SQL Server compact 6.0 on Windows CE 6.0 and Windows Mobile 3.5 Devices.
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ include	SQL Server compact 3.5 header files (sqlce_sync.h, sqlce_err.h, and sqlce_oledb.h ).
% ProgramFiles % \ Microsoft Visual Studio 9.0 \ SDK \ v3.5 \ bootstrapper \ packages \ SQL Server compact edition \ -Or- % ProgramFiles % \ Microsoft Visual Studio 10.0 \ SDK \ v3.5 \ bootstrapper \ packages \ SQL Server compact edition \	Folder series, including the SQL Server compact 3.5 file deployed on a desktop computer using the clickonce function of Visual Studio.
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ Samples	Contains the sample database northwind. SDF. It also contains the northwindoledb and ibuyspy instances installed by the SQL Server compact 3.5 SP1 sample MSI.
% ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ tools	Include the DLL used to manage the SQL Server compact database in SQL Server Management studio. These DLL files are installed by the SQL Server compact 3.5 query tool MSI. These files are as follows: Microsoft. sqlserverce. Client. dll, Microsoft. sqlserverce. enumerator. dll, Microsoft. sqlserverce. managementui. dll, Microsoft. sqlserverce. replwiz. dll, and connwiz.exe.
% ProgramFiles % \ microsoft synchronization services \ ADO. Net \ V1.0 \	The DLL used for sync services for ADO. NET is as follows: Microsoft. synchronization. Data. server. dll, Microsoft. synchronization. Data. dll, Microsoft. synchronization. Data. sqlserverce. dll, and readmessc35.htm.

For information about the 64-bit component, seeManage 64-bit database applications.

Managed Application Development

For device applications, in the Microsoft. NET Compact framework application, addSystem. Data. sqlserverceNamespace reference.System. Data. sqlserverceThe namespace exposes SQL Server compact 3.5 in. NET Compact framework. Then, you can create databases, database tables, and columns, and add data to the database. For more information about generating managed applications for SQL Server compact 3.5 for smart devices, seeSQL Server compact).

When you generate an application from Visual Studio and deploy it to a smart device or a Pocket PC simulation program, Visual Studio automatically checks whether the device is installed. NET Compact framework and SQL Server compact 3.5 client components. If these components are not detected, these components are automatically installed on the device when you deploy any application generated using SQL Server compact 3.5 from Visual Studio for the first time.

To deploy hosted applications to mobile devices from Visual Studio, select start debugging from the Debug menu ". Then, decide whether to deploy it to a connected smart device or a simulation program in the Pocket PC. The default installation path on the device is % ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5.

For desktop applications, in Microsoft. NET Framework applications, addSystem. Data. sqlserverceNamespace reference.System. Data. sqlserverceThe namespace exposes SQL Server compact 3.5 in. NET Framework. Then, you can create databases, database tables, and columns, and add data to the database. How to add a referenceSystem. Data. sqlserverceThe namespace depends on whether you are deploying or generating applications for SQL Server compact 3.5.

• If an application is generated to use the centrally deployed SQL Server compact 3.5 version on the target computer, add a reference from the. NET tab in the Add reference dialog box.

• If you generate an application to use a dedicated SQL Server compact 3.5 version for the application, click the "Browse" tab in the "add reference" dialog box, browse to the % ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ private folder to add references.

For more information about generating managed applications for SQL Server compact 3.5 for desktops, seeSQL Server compact).

To deploy hosted applications to desktops from Visual Studio, select start debugging from the Debug menu ". SQL Server compact 3.5 is installed with Visual Studio, so you do not need to install it on the development computer before deploying the application.

. NET Compact framework and. NET Framework also containSystem. Data. sqlclientNamespace used to develop applications that directly access databases in SQL Server 2005 or later.

Clickonce deployment for deploying hosted applications

clickonce is a new software installation technology supported by SQL Server compact 3.5. It is used to deploy hosted applications on a desktop computer. Clickonce simplifies the deployment of Windows-based applications to Web servers or network file sharing. For administrators, deploying or updating an application is to update files on the server. You do not have to update each client one by one. Visual Studio 2008 provides complete support for applications deployed with clickonce for release and update. Clickonce deployment can be used for projects created using Visual Basic, Visual C #, and Visual J #, but not for Visual C ++.