In this article we will take a brief look at ata Access for Smart Device Extensions.
In this article we will take a brief look at Data Access for Smart Device Extensions. Smart Device Extension allows development for Pocket PC and Windows CE.Net platforms using the same Visual Studio.Net editor. It includes Compact Framework which is an abbreviated version of the .Net Framework suitable for device programming.
Data Access from SDE needs to be able to handle the differences of the mobile devices. It includes the System.Data.SqlClient namespace, which is slightly different from the System.Data.SqlClient namespace in the .Net Framework. Compact Framework does not support the OleDb namespace. Support for SQL Server CE is additionally included in SDE. SQL Server CE adds SQL Server support for mobile devices and supports connections to SQL Server 7 databases and above.
Important functionality provided by SQL Server CE classes :
Important Classes and Namespaces
You can see the similarity between the classes in the SQLCE and the SQLClient namespace. In my next article, we will create a data access example for SDE using C#.
Conclusion
In this example we saw the various data access functionality and features available in SDE and Compact Framework. We also saw the important namespaces and classes for data access in Compact Framework. In conclusion, we can say that in spite of the different models and resources available on devices and desktop applications, .Net provides a common programming model for mobile devices through SDE and Compact Framework.
NOTE: This article should not be construed as a best practices white paper. This article is entirely original, unless specified. Any resemblance to other material is an un-intentional coincidence and should not be misconstrued as malicious, slanderous, or any anything else hereof.
Pro WPF: Windows Presentation Foundation in .NET 3.0