SqlCeRemoteDataAccess.Pull Method (String, String, String, RdaTrackOption, String)
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, _
errorTable As String _
)
'Usage
Dim instance As SqlCeRemoteDataAccess
Dim localTableName As String
Dim sqlSelectString As String
Dim oleDBConnectionString As String
Dim trackOption As RdaTrackOption
Dim errorTable As String
instance.Pull(localTableName, sqlSelectString, _
oleDBConnectionString, trackOption, _
errorTable)
public void Pull(
string localTableName,
string sqlSelectString,
string oleDBConnectionString,
RdaTrackOption trackOption,
string errorTable
)
public:
void Pull(
String^ localTableName,
String^ sqlSelectString,
String^ oleDBConnectionString,
RdaTrackOption trackOption,
String^ errorTable
)
member Pull :
localTableName:string *
sqlSelectString:string *
oleDBConnectionString:string *
trackOption:RdaTrackOption *
errorTable:string -> unit
public function Pull(
localTableName : String,
sqlSelectString : String,
oleDBConnectionString : String,
trackOption : RdaTrackOption,
errorTable : String
)
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.
- errorTable
Type: System.String
The name of the local error table that is created if an error occurs when the Push method is later called to send changes back to SQL Server. This option can be specified only when the RdaTrackOption value is TrackingOn or TrackingOnWithIndexes.