Remote access to mobile databases
Home | Products | Buy | Support | Downloads | Contacts | Forum | Blog Search

open all | close all

Primeworks.Data

Reference | Knowledge Base | Download | Buy | License | Forum | FAQ

Primeworks.Data is the successor of DesktopSqlCe and DataPortSync. It replaces and enhances both products in a single package. This is a desktop .NET 2.0 / 3.5 component that allows your application to:

  • Access local and remote SQL Compact 2.0, 3.0 and 3.5 databases. Local database access is limited to 3.0 and 3.5 because Microsoft never shipped a 2.0 desktop provider. Remote databases can be accessed through RAPI (ActiveSync or WMDC), Sockets and through a serial port (enabling a Bluetooth connectivity scenario). Access to the databases is achieved through two layers of classes: the high level ADO .NET classes and the lower level Core classes. The ADO .NET classes are implemented on top of the Core classes and these provide extra features such as the ability to enumerate the database schema, rename tables and columns, and much more.
  • Import data from Microsoft Access (JET 4.0 and ACE 12.0), SQL Server (2000, 2005 and 2008) to any version of SQL Compact, both local or remote.
  • Export SQL Compact data to Microsof Access, SQL Server and DataSet XML formats (same database versions as above).
  • Synchronize data between a Microsoft Access database and multiple SQL Compact databases through the simplified desktop synchronization mechanism.