Create Compact, Robust Mobile Apps with SQL Server CE 2.0 and the .NET Compact Framework
December 19, 2002[From MSDN Magazine]
The explosive growth of mobile devices in recent years has enabled a new breed of mobile applications for consumers and enterprises alike. In light of this, Microsoft has been cranking out tools and frameworks so software developers will be able to fully exploit the capabilities of these smart devices. Combining these toolsets with a wide array of device options sets the stage for creating the most advanced mobile applications.
Microsoft(R) SQL 2000 Windows(R) CE Edition (also known as SQL Server(TM) CE 2.0) extends even more features of Microsoft SQL Server to Windows CE-based devices. SQL Server CE 2.0 provides all of the critical functionality you need to build robust database applications on the Windows CE or Windows CE .NET operating system (such as data storage, optimizing query processor, multiple connectivity options, and so on). This new edition also provides lateral compatibility with SQL Server 2000. Incredibly, it delivers all of this functionality while still managing to maintain an extremely small memory footprint.
This release provides significant new features and performance improvements over its predecessor. If you've worked with SQL Server CE in the past, you'll notice that performance has been bolstered in this new version and the programming model extended to support the .NET Compact Framework. In this article, we'll take a look at several key features that are new to this release of SQL Server CE and examine some code that highlight these features. Keep in mind that this article does not attempt to address all facets of the SQL Server CE product. It should, however, whet your appetite for creating mobile applications with this new edition of SQL Server CE, whether you're a veteran mobile developer or just getting started.
This article continues at http://msdn.microsoft.com/msdnmag/issues/03/01/SQLServerCE20/default.aspx.