Construtor SqlCeReplication (String, String, String, String, String, String, String, String, String, String)

Inicializa uma nova instância do objeto SqlCeReplication e define as propriedades para conectar uma publicação.

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

Sintaxe

'Declaração
Public Sub New ( _
    internetUrl As String, _
    internetLogin As String, _
    internetPassword As String, _
    publisher As String, _
    publisherDatabase As String, _
    publisherLogin As String, _
    publisherPassword As String, _
    publication As String, _
    subscriber As String, _
    subscriberConnectionString As String _
)
'Uso
Dim internetUrl As String
Dim internetLogin As String
Dim internetPassword As String
Dim publisher As String
Dim publisherDatabase As String
Dim publisherLogin As String
Dim publisherPassword As String
Dim publication As String
Dim subscriber As String
Dim subscriberConnectionString As String

Dim instance As New SqlCeReplication(internetUrl, _
    internetLogin, internetPassword, _
    publisher, publisherDatabase, publisherLogin, _
    publisherPassword, publication, _
    subscriber, subscriberConnectionString)

public SqlCeReplication(
    string internetUrl,
    string internetLogin,
    string internetPassword,
    string publisher,
    string publisherDatabase,
    string publisherLogin,
    string publisherPassword,
    string publication,
    string subscriber,
    string subscriberConnectionString
)

public:
SqlCeReplication(
    String^ internetUrl, 
    String^ internetLogin, 
    String^ internetPassword, 
    String^ publisher, 
    String^ publisherDatabase, 
    String^ publisherLogin, 
    String^ publisherPassword, 
    String^ publication, 
    String^ subscriber, 
    String^ subscriberConnectionString
)

new : 
        internetUrl:string * 
        internetLogin:string * 
        internetPassword:string * 
        publisher:string * 
        publisherDatabase:string * 
        publisherLogin:string * 
        publisherPassword:string * 
        publication:string * 
        subscriber:string * 
        subscriberConnectionString:string -> SqlCeReplication

public function SqlCeReplication(
    internetUrl : String, 
    internetLogin : String, 
    internetPassword : String, 
    publisher : String, 
    publisherDatabase : String, 
    publisherLogin : String, 
    publisherPassword : String, 
    publication : String, 
    subscriber : String, 
    subscriberConnectionString : String
)

Parâmetros

• internetUrl
  Tipo: System. . :: . .String
  A URL usada para conectar o Agente de Servidor do SQL Server Compact 3.5.

• internetLogin
  Tipo: System. . :: . .String
  O nome de logon usado ao conectar o Agente de Servidor do SQL Server Compact 3.5.

• internetPassword
  Tipo: System. . :: . .String
  A senha usada ao conectar o Agente de Servidor do SQL Server Compact 3.5.

• publisher
  Tipo: System. . :: . .String
  O nome do Publicador.

• publisherDatabase
  Tipo: System. . :: . .String
  O nome do banco de dados de publicação.

• publisherLogin
  Tipo: System. . :: . .String
  O nome de logon usado ao conectar o Publicador.

• publisherPassword
  Tipo: System. . :: . .String
  A senha de logon usada ao conectar o Publicador.

• publication
  Tipo: System. . :: . .String
  O nome da publicação que foi habilitado para assinaturas de mesclagem anônimas.

• subscriber
  Tipo: System. . :: . .String
  O nome do Assinante.

• subscriberConnectionString
  Tipo: System. . :: . .String
  A cadeia de conexão OLE DB para o banco de dados do SQL Server Compact 3.5 no dispositivo baseado no Windows Mobile.

Exemplos

Dim repl As SqlCeReplication = Nothing

Try
    ' Instantiate and configure SqlCeReplication object
    '
    'NOTE: when possible, prompt users to enter security 
    'credentials at runtime. If you store credentials in a file, 
    'you must secure the file to prevent unauthorized access.
    '
    repl = New SqlCeReplication()
    repl.InternetUrl = "https://www.adventure-works.com/sqlce/sqlcesa35.dll"
    repl.InternetLogin = "MyInternetLogin"
    repl.InternetPassword = "<enterStrongPassword>"
    repl.Publisher = "MyPublisher"
    repl.PublisherDatabase = "MyPublisherDatabase"
    repl.PublisherLogin = "MyPublisherLogin"
    repl.PublisherPassword = "<enterStrongPassword>"
    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
    //
    //NOTE: when possible, prompt users to enter security 
    //credentials at runtime. If you store credentials in a file, 
    //you must secure the file to prevent unauthorized access.
    //
    repl = new SqlCeReplication();
    repl.InternetUrl = "https://www.adventure-works.com/sqlce/sqlcesa35.dll";
    repl.InternetLogin = "MyInternetLogin";
    repl.InternetPassword = "<enterStrongPassword>";
    repl.Publisher = "MyPublisher";
    repl.PublisherDatabase = "MyPublisherDatabase";
    repl.PublisherLogin = "MyPublisherLogin";
    repl.PublisherPassword = "<enterStrongPassword>";
    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();
}

Consulte também

Referência

SqlCeReplication Classe

Membros SqlCeReplication

Sobrecarga SqlCeReplication

Namespace System.Data.SqlServerCe