Introduction to DesktopSqlCe

Under construction

This article provides a brief introduction to DesktopSqlCe and its basic concepts. You should be familiar with either C# or Visual Basic and with Visual Studio 2005.

What is DesktopSqlCe?

DesktopSqlCe is a .NET class library that allows desktop .NET applications to remotely access SQL CE 2.0 and SQL Compact Edition databases both n the desktop and on mobile devices (accessing SQL CE 2.0 databases is restricted to the device).

What can I do with DesktopSqlCe?

DesktopSqlCe gives you full control of the mobile database. Specifically, you can use the product for the following tasks:

• Create a new database.
• Create and edit the database schema.
• Edit database data - insert, update and delete table records.
• Extract database data using SQL commands.

How does DesktopSqlCe work?

DesktopSqlCe works by establishing a data communication link between the desktop PC and the mobile device. Usually this data link is supported by ActiveSync's RAPI protocol, but you can also use a TCP/IP connection with a specialized device server.

The device requires a special DLL that is freely redistributable: RemSqlCe.dll. In order for the communication to work this DLL file must be copied to the device's \Windows folder. Not being a COM DLL, registration is not required.

On the desktop side the dssce.dll file is used to make the remote connections to RemSqlCe.dll. This file should be placed anywhere in the desktop's DLL search path, although most users will simply put it in the C:\Windows\System32 folder.

using Primeworks.DesktopSqlCe;

Support / Knowledge Base / DesktopSqlCe / Introduction to DesktopSqlCe