SQL Server Compact Edition Native Programming

By using Microsoft Visual C++ and Visual C++ for Devices, you can apply your knowledge of Visual C++ to develop desktop and smart device applications that use Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition). Visual C++ for Devices is included with Visual Studio 2005, which provides an IDE for developing smart device applications.

SQL Server Compact Edition is implemented as a set of dynamic-link libraries (DLLs) that simplify data access. You use OLE DB to access a SQL Server Compact Edition database in Visual C++ applications. OLE DB is a low-level data interface technology that provides granular capabilities for data access. Of all the data access APIs, OLE DB for SQL Server Compact Edition provides the fastest data manipulation and access.

The following table describes the topics in this section:

Topic Description

SQL Server Compact Edition Engine Object Programming

Describes the methods and properties used to create, use, and delete a SQL Server Compact Edition database when you use Visual C++ for Devices.

SQL Server Compact Edition Remote Data Access Programming

Describes the methods and properties used to implement remote data access (RDA) with SQL Server Compact Edition when you use Visual C++ for Devices.

SQL Server Compact Edition Replication Programming

Describes the methods and properties used to implement merge replication with SQL Server Compact Edition when you use Visual C++ for Devices.

Programming the Native Error Object (SQL Server Compact Edition)

Describes the methods and properties used to implement error handling with SQL Server Compact Edition when you use Visual C++ for Devices.

See Also

Reference

OLE DB Provider Reference (SQL Server Compact Edition)

Help and Information

Getting SQL Server Compact Edition Assistance