Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Dec 20, 2002

Create Compact, Robust Mobile Apps with SQL Server CE 2.0 and the .NET Compact Framework

By DatabaseJournal.com Staff

[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.

Back to Database Journal Home

Database News Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM