SqlCeReplication Constructor (String, String, String, String, String, String, String, String)
Initializes a new instance of the SqlCeReplication object and sets the required properties for connecting to a publication.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Syntax
'Declaration
Public Sub New ( _
internetUrl As String, _
internetLogin As String, _
internetPassword As String, _
publisher As String, _
publisherDatabase As String, _
publication As String, _
subscriber As String, _
subscriberConnectionString As String _
)
'Usage
Dim internetUrl As String
Dim internetLogin As String
Dim internetPassword As String
Dim publisher As String
Dim publisherDatabase As String
Dim publication As String
Dim subscriber As String
Dim subscriberConnectionString As String
Dim instance As New SqlCeReplication(internetUrl, internetLogin, internetPassword, publisher, publisherDatabase, publication, subscriber, subscriberConnectionString)
public SqlCeReplication (
string internetUrl,
string internetLogin,
string internetPassword,
string publisher,
string publisherDatabase,
string publication,
string subscriber,
string subscriberConnectionString
)
public:
SqlCeReplication (
String^ internetUrl,
String^ internetLogin,
String^ internetPassword,
String^ publisher,
String^ publisherDatabase,
String^ publication,
String^ subscriber,
String^ subscriberConnectionString
)
public SqlCeReplication (
String internetUrl,
String internetLogin,
String internetPassword,
String publisher,
String publisherDatabase,
String publication,
String subscriber,
String subscriberConnectionString
)
public function SqlCeReplication (
internetUrl : String,
internetLogin : String,
internetPassword : String,
publisher : String,
publisherDatabase : String,
publication : String,
subscriber : String,
subscriberConnectionString : String
)
Parameters
- internetUrl
The URL used to connect to the SQL Server Mobile Server Agent.
- internetLogin
The login name used when connecting to the SQL Server Mobile Server Agent.
- internetPassword
The password used when connecting to the SQL Server Mobile Server Agent.
- publisher
The name of the Publisher.
- publisherDatabase
The name of the publication database.
- publication
The publication name that has been enabled for anonymous merge subscriptions.
- subscriber
The name of the Subscriber.
- subscriberConnectionString
The OLE DB connection string for the SQL Server Mobile database on the Windows Mobile-based device.
Example
This example uses the AddSubscription and Synchronize methods to create a new subscription database.
Dim repl As SqlCeReplication = Nothing
Try
' Instantiate and configure SqlCeReplication object
'
repl = New SqlCeReplication()
repl.InternetUrl = "https://www.adventure-works.com/sqlmobile/sqlcesa30.dll"
repl.InternetLogin = "MyInternetLogin"
repl.InternetPassword = "<password>"
repl.Publisher = "MyPublisher"
repl.PublisherDatabase = "MyPublisherDatabase"
repl.PublisherLogin = "MyPublisherLogin"
repl.PublisherPassword = "<password>"
repl.Publication = "MyPublication"
repl.Subscriber = "MySubscriber"
repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf"
' Create the local SQL Mobile Database subscription
'
repl.AddSubscription(AddOption.CreateDatabase)
' Synchronize to the SQL Server to populate the Subscription
'
repl.Synchronize()
Catch
' Handle errors here
'
Finally
' Dispose the repl object
'
repl.Dispose()
End Try
SqlCeReplication repl = null;
try
{
// Instantiate and configure SqlCeReplication object
//
repl = new SqlCeReplication();
repl.InternetUrl = "https://www.adventure-works.com/sqlmobile/sqlcesa30.dll";
repl.InternetLogin = "MyInternetLogin";
repl.InternetPassword = "<password>";
repl.Publisher = "MyPublisher";
repl.PublisherDatabase = "MyPublisherDatabase";
repl.PublisherLogin = "MyPublisherLogin";
repl.PublisherPassword = "<password>";
repl.Publication = "MyPublication";
repl.Subscriber = "MySubscriber";
repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf";
// Create a local SQL Mobile Database subscription
//
repl.AddSubscription(AddOption.CreateDatabase);
// Synchronize to the SQL Server database
//
repl.Synchronize();
catch (SqlCeException)
{
// Handle errors here
//
finally
{
// Dispose the repl object
//
repl.Dispose();
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .
Platforms
Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.
Version Information
.NET Compact Framework
Supported in: 2.0, 1.0
See Also
Reference
SqlCeReplication Class
SqlCeReplication Members
System.Data.SqlServerCe Namespace