This documentation is archived and is not being maintained.

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.

See Also