SQL Server CE Software Environment requirements

Because SQL Server Compact Edition and SQL Server 2005 are contemporaries, interoperability and convergence between them are better than previous versions of SQL Server, so if you want to consider using SQL Server 2005 For data synchronization with merge replication and remote data access technologies in the Compact edition, it is a good idea to use SQL Server 2005 as the back-end database.

Now any computer that can run Visual Studio 2005 can meet the hardware requirements of this topic (specific hardware and software requirements You can view Books Online in the SQL Server edition Compact).

The following is a software environment that the author uses to develop the SQL Server Edition Compact program:

The following are the referenced contents: · Windows XP SP2 · Visual Studio 2005 · Windows Mobile 6.0 Professional SDK · Microsoft ActiveSync 4.5 · Internet Explorer 6.0 · Iis · SQL Server 2005

Because in the earlier part of this topic, it is mainly about how to operate the SQL Server Edition compact via ado.net on the Windows Mobile device side, so we don't have to consider the SQL Server Compact Edition the problem with SQL Server 2005 for data synchronization. As a result, SQL Server 2005 and IIS can be installed for the time being, and when using merge replication and remote data access technologies, I will detail the SQL Server Compact Edition and SQL Server The configuration process required for data synchronization between 2005.

The configuration process for the Smart Device development environment

Now let's introduce the basic requirements for developing the SQL Server Compact Edition mobile device side. We typically use Visual Studio Professional and a higher version for the development of smart device programs (not currently supported by Visual Studio Express). In the process of installing Visual Studio 2005, you simply select the Smart Device programmable radio box in Figure 1, and you can use Visual C # to develop the smart Device program for managed code after installation.

Figure 1 Selecting "Smart Device programmable technology"

When we develop smart device programs for a particular platform, we often need to install the corresponding SDK (software development package) beforehand. For example, to develop an application for Windows Mobile 6.0, the Windows Mobile 6 SDK is installed first, otherwise visual Studio 2005 does not have the option to develop Windows Mobile 6 Smart device. To do this, after we install Visual Studio 2005, we need to install the ActiveSync software so that we can continue to complete the SDK installation for a specific platform, which I hope you must pay attention to.

ActiveSync can also support PPC and Microsoft Smartphones (Smartphone), which makes it easy to synchronize data between PCs and PPC or smartphones. ActiveSync not only can sync files, emails and schedules, but also has many additional functions like SMS. In addition, users of Windows mobile devices can access the Internet by connecting to the PC. ActiveSync can be said to be a bridge between PC and mobile device.

Now the latest ActiveSync version is 4.5, the Chinese version of the software can be downloaded from the link: http://download.microsoft.com/download/7/e/c/ 7ecbd388-7fb5-4e3e-b57f-12eaf7eb6136/setup.msi

When the ActiveSync is installed, you will be prompted to restart your computer to complete the settings. The ActiveSync interface is shown in Figure 2:

Figure 2 ActiveSync 4.5 Simplified Chinese version

As mentioned earlier, when we need to develop a specific platform for Windows Mobile applications, we need to install the appropriate SDK. Windows Mobile 6.0 will be used as a platform for development in this topic, because the. Net Compact Framework 2.0 SP1 and SQL Server compact E are already built into the ROM of Windows Mobile 6.0 devices. Dition, coupled with the fact that more and more products have adopted Windows Mobile 6.0 systems in recent months, it is not long before Windows Mobile 6.0 replaces Windows Mobile 5.0 as the mainstream operating system. Of course, all programs in this topic can also be run on Windows Mobile 5.0 without any modification. This is because Windows Mobile 6.0 and Windows Mobile 5.0 are based on Windows CE 5.0, except that Windows Mobile 6.0 adds some new features, such as Vista style, based on the original 5.0.

The latest version of the SDK for Windows Mobile 6.0 can contain two versions, one for the Pocket PC and the Pocket PC Phone Edition development of the Professional version, The other is a standard version developed for Smartphone. In this topic, we developed primarily for Pocket PC Phone Edition, which has the ability to communicate with the Pocket PC, and the hardware performance is significantly higher than smartphone, so installing Windows under general Conditions Mobile 6.0 Professional SDK.

The download address for the Windows Mobile 6.0 Professional SDK is as follows: http://download.microsoft.com/download/f/2/3/ F232f773-7edc-4300-be07-d3b76a5b3a91/windows%20mobile%206%20professional%20sdk%20refresh.msi

The download address for the Windows Mobile 6.0 Standard SDK is as follows:
http://download.microsoft.com/download/f/2/3/f232f773-7edc-4300-be07-d3b76a5b3a91/Windows%20Mobile%206% 20standard%20sdk%20refresh.msi

After the Windows Mobile 6.0 Professional SDK is installed, you can use the "start"-"All Programs"-"Windows Mobile 6 SDK"-"line of Business Extras"-"mobile" of Business Solution accelerator "Download a mobile industry solution similar to the logistics system, and I will provide a detailed analysis and explanation of the project in the last part of this topic." Some of the functional modules of the mobile industry explanation program are shown in 3:

Figure 3 "Mobile Line of Business Solution accelerator" Login module and create New Order module

You can also download the example code for "Mobile Line of Business Solution accelerator" directly from this link: http://download.microsoft.com/download/7/e/6/ 7e635836-bf36-436b-b8cc-0b16c74ba9b7/mobilelineofbusinesssolutionaccelerator.msi

By default, the installation of the Windows Mobile 6.0 Professional SDK automatically installs the English Device Emulator for Windows Mobile 6.0, and the Chinese Device Emulator is required to be installed separately for installation, Windows Mobile 6.0 The Chinese emulator is shown in Figure 4.

Windows Mobile 6 Professional Chinese image download address: http://download.microsoft.com/download/0/1/2/ 012bfbba-9fe5-4e68-86c9-d434446d97dd/0804/windows%20mobile%206%20professional%20images%20 (CHS). msi

Windows Mobile 6 Standard Chinese image download address: http://download.microsoft.com/download/0/1/2/ 012bfbba-9fe5-4e68-86c9-d434446d97dd/0804/windows%20mobile%206%20standard%20images%20 (CHS). msi

Figure 4 The "Today" interface of the Windows Mobile 6 Chinese Emulator

When the Windows Mobile 6.0 SDK is installed, we can develop smart device programs for Windows Mobile 6.0 through Visual Studio 2005来. As shown in Figure 5, we will find more "Windows Mobile 6 Professional" in the "Smart Device" column, and we can create five different types of projects with the template on the right.

Figure 5 Creating a Windows Mobile 6.0 Smart Device Program in Visual Studio 2005

Next we are installing the SDK for the SQL Server Compact Edition, which contains the SQL Server Compact Edition runtime (which must be installed) to develop and deploy applications on the desktop. And for mobile devices of different types of processors, the corresponding SQL Server Compact Edition component installation package is also different. In addition, the SDK contains the SQL Server Compact Edition Help documentation, which is probably the only authoritative reference for the current Learning SQL Server Edition compact.

The download page for the SQL Server Compact Edition SDK is still not available at the time of the writer's current writing, which has probably lasted about six months. Below I will give the SQL Server Compact Edition SDK direct Download Address:

SQL Server Compact Edition SDK Chinese: http://download.microsoft.com/download/0/9/4/ 094d27fe-8d7f-4b0b-8130-555ed2c8b366/ssce31sdk-chs.msi

SQL Server Compact Edition SDK English: http://download.microsoft.com/download/e/5/b/ E5b19eb6-4141-4dba-a1fb-e95693c1538f/ssce31sdk-enu.msi

After the SQL Server Compact Edition SDK is installed, you can find a file named "Sqlserverce31-zh-chs.msi" in the "\v3.1\sdk\bin\desktop" subfolder of its installation directory. This file is the SQL Server Compact Edition runtime that is used to develop and deploy applications on desktops. Because smart device managed programs that use the SQL Server Compact Edition need to refer to the "System.Data.SqlServerCe" namespace, which is also created by the " System.Data.SqlServerCe.resources.dll file, you must install the SQL Server Compact Edition Runtime on your computer.

The "Ssce31bol-chs.msi" file in the "V3.1\sdk\docs\zh-chs" subfolder is the SQL Server Compact Edition Help document, which is recommended for installation because of its very detailed content. In the "\v3.1\sdk\bin\wce500" subfolder, the SQL Server Compact Edition component installation package for different types of processors is included, as shown in Figure 6. The next section details how to install the components of the SQL Server edition Compact into a mobile device.

Figure 6 The SQL Server Compact Edition component installation package for 7 different processors