How-to

How to Insert, Update and Delete data with SqlCeRowset
This article explains how to use the SqlCeRowset class to insert, update and delete records on a SQL Compact Edition database without going through the query processor.

How to enumerate the database schema with DesktopSqlCe
This article otlines the steps required to enumerate a SQL Mobile database schema with DesktopSqlCe.

Introduction to DesktopSqlCe
What is DesktopSqlCe? What can it do for me? This article explains the basic concepts of DesktopSqlCe.

Using the Pipe to install RemSqlCe.dll
This article describes how you can use the Pipe object to automatically install the device component file (RemSqlCe.dll) using an ActiveSync connection.

DesktopSqlCe Connection properties
This article describes what SqlCeConenction.ConnectionString properties are available and how they are parsed by the desktop code.

Using the DesktopSqlCe License object
This article explains how to use the License object to enable your DesktopSqlCe license.

Reading the Version Number
This article descrives how to read and interpret the version number of the DesktopSqlCe DLL files.

Enabling RAPI connections
By default, Windows Mobile 5 does not accept RAPI calls. This features stops the remote data access products from working in this platform. Read here how to circumvent this problem.

Installing SQL Mobile
This article describes how to install SQL Mobile in a device so you can correctly use Primework's products.

Troubleshooting

You get a "System.NullReferenceException: Object reference not set to an instance of an object." error when calling SqlCeConnection.BeginTransaction
This article explains how to patch your DesktopSqlCe sources to avoid this error.

RapiInvoke failed error
This article explains what to do when you get the above error.

Unknown publisher warning
When using any of the remote data access products, you may get the following warning: "Starting this program requires a component from an unknown publisher. You should start the program only if you trust the component's publisher. Do you want to continue?"

Documentation

SqlCeDataReaderMode
This article explains how the SqlCeDataReaderMode impacts the performance of your application and how to decide which mode you should choose depending on your particular needs.

Support / Knowledge Base / DesktopSqlCe