RDA Object Methods
Applications use the RDA object to access a database on a remote instance of Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) and populate a local SQL Server Compact Edition database with the data. The following table describes the methods that the RDA object supports.
| Method | Description |
|---|---|
Retrieves data from a remote Microsoft SQL Server database and stores that data in a single table in a local SQL Server Compact Edition database. |
|
Sends changes from a locally-tracked SQL Server Compact Edition table back to the original remote SQL Server table. |
|
Submits SQL statements for execution on a remote SQL Server database. |
Remarks
Each of the three RDA object methods contains an OLEDBConnectionString property. This property provides the OLE DB connection string that is used when connecting to the remote SQL Server database. The OLE DB connection string provides connectivity information, including security information. For more information about the OLEDBConnectionString, see LocalConnectionString Property (SQL Server Compact Edition).
See Also
Other Resources
Introducing Remote Data Access