If you refer to the 70-540 Exam study guide you will see references to a database product called SQL Server 2005 Everywhere Edition. This product technically doesn’t exist!
Originally there was a database product for Pocket PC devices called SQL Server CE (aka SQL CE). For similiar reasons to those mentioned in my blog post about Windows Mobile naming conventions, the product name for the SQL Server CE database engine has changed over time.
This leads to a confusing mismatch of names through out the various developer tools and documentation, especially when Visual Studio and SQL Server CE releases were not in sync with each other. As a simple example the ADO.NET data provider for SQL Server 2005 Mobile Edition databases still lives within the System.Data.SqlServerCe namespace for backwards compatability reasons.
A brief version history
There have been atleast 5 major releases of the SQL Server CE database engine as follows.
|SQL Server 2000 Windows CE Edition||SQL CE 1.0|
|SQL Server 2000 Windows CE Edition||SQL CE 1.1|
|SQL Server 2000 Windows CE Edition||SQL CE 2.0|
|SQL Server 2005 Mobile Edition||SQL CE 3.0|
|SQL Server 2005 Compact Edition*||SQL CE 3.1|
|SQL Server Compact 3.5||SQL CE 3.5|
* Was also called SQL Server 2005 Everywhere Edition.
Visual Studio 2005 originally came with support for SQL Server 2005 Mobile Edition. However with Service Pack 1 (and an optional download) it is possible to update it to support development against SQL Server Compact Edition.
The 70-540 Study Guide was obviously produced before SQL Server Compact Edition was officially released. Prior to final release the product was scheduled to be named SQL Server Everywhere edition.
There is little difference between SQL Server 2005 Mobile Edition (v3.0) and SQL Server 2005 Compact Edition (v3.1) on PDAs, the major difference is that SQL Server 2005 Compact Edition was the first release to support running the database engine on an X86 desktop PC. Prior to this release SQL Server CE only supported running on Windows CE based devices such as Pocket PC PDAs.
I am about to renew my effort to post blog entries for my 70-540 Study Guide. This blog post was designed to setup the stage for a series of posts about database access within the .NET Compact Framework environment.