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

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

'Declaration
Public Sub Pull ( _
    localTableName As String, _
    sqlSelectString As String, _
    oleDBConnectionString As String, _
    trackOption As RdaTrackOption _
)
'Usage
Dim instance As SqlCeRemoteDataAccess
Dim localTableName As String
Dim sqlSelectString As String
Dim oleDBConnectionString As String
Dim trackOption As RdaTrackOption

instance.Pull(localTableName, sqlSelectString, _
    oleDBConnectionString, trackOption)
public void Pull(
    string localTableName,
    string sqlSelectString,
    string oleDBConnectionString,
    RdaTrackOption trackOption
)
public:
void Pull(
    String^ localTableName, 
    String^ sqlSelectString, 
    String^ oleDBConnectionString, 
    RdaTrackOption trackOption
)
member Pull : 
        localTableName:string * 
        sqlSelectString:string * 
        oleDBConnectionString:string * 
        trackOption:RdaTrackOption -> unit 
public function Pull(
    localTableName : String, 
    sqlSelectString : String, 
    oleDBConnectionString : String, 
    trackOption : RdaTrackOption
)

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.
  • 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.

See Also

Reference

SqlCeRemoteDataAccess Class

Pull Overload

System.Data.SqlServerCe Namespace