SQL Server Compact Edition with the .NET Compact Framework
Microsoft SQL Server 2005 Compact Edition (formerly Microsoft SQL Server 2005 Mobile Edition) provides the storage functionality of SQL Server on smart devices running Microsoft Windows CE .NET or the Windows Mobile operating system, while providing developers with a consistent programming model for rapid application development. SQL Server Compact Edition delivers essential relational database functionality in a small footprint:
A compact Database Engine and a robust query optimizer.
Integration with
Management tools: and Express
Integration with Visual Studio 2005.
Remote data access and merge replication to synchronize data
.NET Framework and .NET Compact Framework Data Provider for SQL Server Compact Edition (System.Data.SqlServerCe).
Support for ADO .NET and the OLE DB Provider for SQL Server Compact Edition.
A subset of SQL syntax.
Support for transactions
Column-level and row-level tracking
An updatable, scrollable cursor
Deployed as an embedded database on desktop computers, mobile devices, and Tablet PCs
Supports ClickOnce deployment technology
The System.Data.SqlServerCe namespace exposes SQL Server Compact Edition in the Microsoft .NET Compact Framework. In addition, the .NET Compact Framework also includes the System.Data.SqlClient namespace for developing smart device applications that directly access databases in Microsoft SQL Server 7.0 or later.
For more information about SQL Server Compact Edition and its use with the .NET Compact Framework, see SQL Server 2005 Compact Edition Books Online.