Getting Started SQLCE | SQL Compact Edition | SQL Everywhere
I have recently joined a project that looks for a In-Memory Database for client-side caching solution. I am currently conducting the POC of using SQLCE | SQL Compact Edition | SQL Everywhere as an alternative.
SQL Server 2005 Compact Edition was previously named SQL Server 2005 Everywhere Edition during the product development phase. Customers have communicated to Microsoft through the pre-release community technology preview (CTP) program and other channels that this product name may cause potential confusion with other database product names in the industry. Microsoft has taken this feedback seriously and has accordingly changed the official product name.
To get started, I have searched and got to this list of resources that will help anyone to get started as well.
Introductory Resources:Getting started with SQL Server 2005 Everywhere Edition
MSDN Technical papers:
Microsoft SQL Server 2005 Compact Edition Overview White Paper
SQL Server 2005 Compact Edition Data Access with the SqlCeResultSet and Visual C# .NET
.NET Rocks! – Josh Holmes on SQL Everywhere and More