SubscriberConnectionString 属性

指定 SQL Server Compact 3.5 数据库的连接字符串。

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

语法

声明
Public Property SubscriberConnectionString As String
    Get
    Set
用法
Dim instance As SqlCeReplication
Dim value As String

value = instance.SubscriberConnectionString

instance.SubscriberConnectionString = value

public string SubscriberConnectionString { get; set; }

public:
property String^ SubscriberConnectionString {
    String^ get ();
    void set (String^ value);
}

member SubscriberConnectionString : string with get, set

function get SubscriberConnectionString () : String
function set SubscriberConnectionString (value : String)

属性值

类型：System. . :: . .String
SQL Server Compact 3.5 数据库的连接字符串。

注释

除“持久性安全信息”外，此属性支持所有其他 ConnectionString 属性。

如果使用 AddSubscription 方法创建新数据库，则支持区域设置标识符值。请用唯一的 LCID 表示区域设置标识符的值。若要查找唯一 LCID 值的列表，请参阅“SQL Server Compact 3.5 联机丛书的 SQL 参考”一节中的“COLLATE”主题。必须确保创建数据库的设备支持该区域设置。

指定 [SubscriberConnectionString] 的数据源属性时，应使用数据库文件的完整路径，而非相对路径。

示例

下面的示例设置 SqlCeReplication 对象的 SubscriberConnectionString 属性。

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 成员

System.Data.SqlServerCe 命名空间