DesktopSqlCe Manual

Introduction

DesktopSqlCe is a desktop .NET Framework 2.0  component that allows your desktop applications to remotely access SQL Compact Edition databases in mobile or embedded devices and also on desktop PCs. You can access data stored on SQL Compact Edition databases through the well-known data access classes you find on .NET Compact Framework as well as a set of lower-level classes that provide greater control of the SQL database engine.

With DesktopSqlCe your applications will be able to:

• Create, open and close SQL Compact Edition databases;
• Enumerate tables, columns, indexes, and constraints;
• Rename tables and columns;
• Change column types converting the data on the fly;
• Perform very fast bulk insertions and data retrieval;
• Execute SQL commands (DDL and DML);
• Open tables in direct mode, which allows you to insert, update and delete data without using SQL DML commands;
• Access the remote device via ActiveSync or TCP/IP;
• Enumerate files and folders on the remote device.

See also: What is DesktopSqlCe?

Support / Manuals / DesktopSqlCe / Introduction