通过

SqlCeReplication 构造函数 (String, String, String, String, String, String, String, String, String, String)

初始化 SqlCeReplication 对象的新实例，并设置连接到发布内容时必需的属性。

命名空间：  System.Data.SqlServerCe
程序集：  System.Data.SqlServerCe（在 System.Data.SqlServerCe.dll 中）

语法

声明
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 _
)
用法
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
)

参数

  • internetUrl
    类型：System. . :: . .String
    连接到 SQL Server Compact 3.5 服务器代理时使用的 URL。
  • internetLogin
    类型：System. . :: . .String
    连接到 SQL Server Compact 3.5 服务器代理时使用的登录名。
  • internetPassword
    类型：System. . :: . .String
    连接到 SQL Server Compact 3.5 服务器代理时使用的密码。
  • subscriberConnectionString
    类型：System. . :: . .String
    基于 Windows Mobile 的设备上 SQL Server Compact 3.5 数据库的 OLE DB 连接字符串。

示例

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();
}

请参阅

参考

SqlCeReplication类

SqlCeReplication 成员

SqlCeReplication 重载

System.Data.SqlServerCe 命名空间