Professional Windows® Embedded Compact 7

COMPACT DATABASE REQUIREMENTS

In this section you look at what is needed on the development machine, what is needed in the target operating system, and what is needed by a Managed Code application to build, run, and deploy a Compact SQL application on a Compact 7 device.

Compact 7 Device Requirements

Compact 7 has a native component and a Managed Code Provider for SQL Server Compact. Both are located in the Catalog, as shown in Figure 20-4. The Managed Code provider has a dependency on the native driver in that the Managed Code component calls the native component: With SQL Compact Managed Provider checked, SQL Compact (Native) is a required component.

FIGURE 20-4

Figure 20-5 shows a list of the SQL Compact DLLs on a deployed Compact 7 operating system that has the SQL Compact components included in Figure 20-4. The main DLL is sqlcecompact35.dll.

FIGURE 20-5

The Compact SQL file version with Compact 7 is a slightly later version (3.5.8154.0) than SQL Server Compact 3.5 SP 2 (3.5.8080.0) but is compatible with this for development purposes. You should make sure that the required SQL Compact service packs are installed on your development machine for all the SQL Compact components. For SP2 the main DLL file is version 3.5.8080.0. You can see the installed versions in the Program ...