This topic has not yet been rated - Rate this topic

SqlCeRemoteDataAccess.Pull Method (String, String, String, RdaTrackOption)

Visual Studio 2010

This type has a SecurityCriticalAttribute attribute, which restricts it to internal use by the .NET Framework for Silverlight class library. Application code that uses any member of this type throws a MethodAccessException.

[SECURITY CRITICAL]

Downloads data from a remote SQL Server database and stores that data in a single table in a local SQL Server Compact database.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

Syntax

C++

JScript

public void Pull(
	string localTableName,
	string sqlSelectString,
	string oleDBConnectionString,
	RdaTrackOption trackOption
)

Parameters

localTableName: Type: System.String
The name of the SQL Server Compact table that will receive the extracted SQL Server records. An error occurs if the table already exists.

sqlSelectString: Type: System.String
Any valid Transact-SQL statement—including SELECT statements and stored procedures—that specifies which table, columns, and records to extract from the SQL Server database for storing in the SQL Server Compact database.

oleDBConnectionString: Type: System.String

trackOption: Type: System.Data.SqlServerCe.RdaTrackOption
The option indicating whether SQL Server Compact tracks changes made to the pulled table, and whether the indexes that exist on the table being pulled are brought down to the device with the PRIMARY KEY constraints.

Reference

SqlCeRemoteDataAccess Class

Pull Overload

System.Data.SqlServerCe Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)