Difference of SQL ce 3.0 and SQL ce 3.5

  In. net campact framework commonly used SQL ce database for data storage, SQL CE is a extension *. the SDF file database was named SQL Server for Windows CE and SQL Server mobile edition. The latest version is named SQL Server compact edition, which is called SQL ce. This article describes the compatibility between SQL ce 3.0 and SQL ce 3.5.

The development of SQL ce under. Net campact framework uses system. Data. sqlserverce. dll in a unified manner. The namespace encapsulated by this DLL is consistent with that of the class, soProgramCodeIs unified. However, because the *. SDF data file format is different, Ms provides different versions of system. Data. sqlserverce. dll, and its related components are stored in different locations. By default, the cf.net version is 2.0 and the SQL ce version is 3.0 by default. The cf.net version is 3.5 by default in vs2008 development, but you can select 2.0. The default SQL ce version is 3.5. Generally stored in C: Program Files \ Microsoft SQL Server \ compact editionv3.5devices. SDF data file and system. data. sqlserverce. DLL is one-to-one binding, and 3.5 of the SDF data files can only use 3.5 of sqlserverce. DLL, 3.0 of SDF data files can only use 3.0 of sqlserverce. DLL.