Programming Articles
SQL Server 2005 Compact Edition Tutorial: CRUD - (Create, Read, Update, and Delete) - Updated 9/24/2007
'SQL Server 2005 Compact Edition Tutorial: CRUD - (Create, Read, Update, and Delete)' -
Source code
SQL Server 2005 Compact
Edition Information:
Here's some background information on SQL Server Compact Edition:
In order to more effectively use SQL Server CE on Visual Studio 2005 SP1, add this tool:
Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 Service Pack 1
Brief Description
The download is installed after the installation of Visual Studio 2005 SP1 and updates the Smart Device Development components in Visual Studio 2005 SP1 with the SQL Server 2005 Compact Edition design time UI/Dialogs, device CAB files, and includes new features like Click Once support.
From Microsoft, here's
An introduction to SQL Server 2005 Compact Edition. This document provides an insight into some of the features of
SQL Server CE, links for the install files, as well as some of the system's vulnerabilities, and workarounds for them.
Brief Description
SQL Server 2005 Compact Edition Developer SDK contains the files required for installing
SQL Server 2005 Compact Edition on mobile devices, desktop and tablet PC. It also has the Help File, and the Header files for native development, and the Northwind sample application.
Follow along with these self-paced tutorials to learn how to rapidly develop applications with SQL Server 2005 Compact Edition using familiar programming models and management interface. These tutorials include step-by-step instructions and exercise scripts for performing tasks related to SQL Server 2005 Compact Edition.
SQL Server Everywhere Blog ( NOTE:
SQL Server Everywhere was one of the many names given to
SQL Server Compact Edition in it's earlier, pre-release, forms. )
Blog with several good
SQL Server CE code examples
An
screencast / video overview of the different programming options for
SQL Server Everywhere Edition including an updateable resultset (SqlCeResultSet)