SqlCeRemoteDataAccess Class

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]

Initializes a new instance of the SqlCeRemoteDataAccess object. For more information about Remote Data Access, see Using Remote Data Access (RDA).

Inheritance Hierarchy

System.Object
  System.Data.SqlServerCe.SqlCeRemoteDataAccess

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

Syntax

'Declaration
<SecurityCriticalAttribute(SecurityCriticalScope.Everything)> _
<PermissionSetAttribute(SecurityAction.Demand, Name := "FullTrust")> _
Public NotInheritable Class SqlCeRemoteDataAccess _
    Implements IDisposable
'Usage
Dim instance As SqlCeRemoteDataAccess
[SecurityCriticalAttribute(SecurityCriticalScope.Everything)]
[PermissionSetAttribute(SecurityAction.Demand, Name = "FullTrust")]
public sealed class SqlCeRemoteDataAccess : IDisposable
[SecurityCriticalAttribute(SecurityCriticalScope::Everything)]
[PermissionSetAttribute(SecurityAction::Demand, Name = L"FullTrust")]
public ref class SqlCeRemoteDataAccess sealed : IDisposable
[<SealedAttribute>]
[<SecurityCriticalAttribute(SecurityCriticalScope.Everything)>]
[<PermissionSetAttribute(SecurityAction.Demand, Name = "FullTrust")>]
type SqlCeRemoteDataAccess =  
    class
        interface IDisposable
    end
public final class SqlCeRemoteDataAccess implements IDisposable

The SqlCeRemoteDataAccess type exposes the following members.

Constructors

  Name Description
Public method SqlCeRemoteDataAccess() Initializes a new instance of the SqlCeRemoteDataAccess object.
Public method SqlCeRemoteDataAccess(String, String) Initializes a new instance of the SqlCeRemoteDataAccess object and configures it for anonymous access to Microsoft Internet Information Services (IIS).
Public method SqlCeRemoteDataAccess(String, String, String, String) Initializes a new instance of the SqlCeRemoteDataAccess object and configures it for a Basic or Integrated Windows authentication to Microsoft Internet Information Services (IIS).

Top

Properties

  Name Description
Public property CompressionLevel Specifies the amount of compression that will be used by the compression routines during Push and Pull operations.
Public property ConnectionManager Enables the SqlCeRemoteDataAccess object to use the smart device's Connection Manager API to establish a network connection. The connection is released at the end of synchronization.
Public property ConnectionRetryTimeout Specifies how long (in seconds) the SQL Server Compact client will continue to retry sending failed requests.
Public property ConnectTimeout Gets or sets the amount of time, in milliseconds, that the SqlCeRemoteDataAccess object waits for a connection to the server.
Public property InternetLogin Specifies the Microsoft Internet Information Services (IIS) login name used when connecting to the SQL Server Compact Server Agent.
Public property InternetPassword Specifies the Microsoft Internet Information Services (IIS) password used when connecting to the SQL Server Compact Server Agent.
Public property InternetProxyLogin Specifies the login name used when connecting to a proxy server (defined in the InternetProxyServer property) that requires authentication.
Public property InternetProxyPassword Specifies the password used when connecting to a proxy server (defined in the InternetProxyServer property) that requires authentication.
Public property InternetProxyServer Specifies the proxy server to use when accessing the HTTP resource specified in the InternetUrl property.
Public property InternetUrl Specifies the URL used to connect to the SQL Server Compact Server Agent. The SQL Server Compact Server Agent is the Microsoft Internet Information Services (IIS) ISAPI DLL that connects the SQL Server Compact client to the Microsoft SQL Server Database. This property must be specified.
Public property LocalConnectionString Specifies the connection string for the SQL Server Compact database.
Public property ReceiveTimeout Gets or sets the amount of time, in milliseconds, that the SqlCeRemoteDataAccess object waits for the response to a server request.
Public property SendTimeout Gets or sets the amount of time, in milliseconds, that the SqlCeRemoteDataAccess object waits to send a request to the server.

Top

Methods

  Name Description
Public method Dispose Releases all unmanaged resources.
Public method Equals (inherited from Object)
Protected method Finalize (inherited from Object)
Public method GetHashCode (inherited from Object)
Public method GetType (inherited from Object)
Protected method MemberwiseClone (inherited from Object)
Public method Pull(String, String, String) Downloads data from a remote SQL Server database and stores that data in a single table in a local SQL Server Compact database.
Public method Pull(String, String, String, RdaTrackOption) Downloads data from a remote SQL Server database and stores that data in a single table in a local SQL Server Compact database.
Public method Pull(String, String, String, RdaTrackOption, String) Downloads data from a remote SQL Server database and stores that data in a single table in a local SQL Server Compact database.
Public method Push(String, String) Transmits changes from a pulled tracked table in SQL Server Compact back to the originating SQL Server table. These changes are individually applied to the server in separate transactions.
Public method Push(String, String, RdaBatchOption) Transmits changes from a pulled tracked table in SQL Server Compact back to the SQL Server table. These changes can be either individually applied to the server or batched together in a single transaction.
Public method SubmitSql Submits SQL statements for execution on a database in SQL Server on a remote server.
Public method ToString (inherited from Object)

Top

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

System.Data.SqlServerCe Namespace