SqlConnectionStringBuilder.Values 属性
定义
重要
一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。 对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。
获取一个包含 ICollection 中的值的 SqlConnectionStringBuilder。
public:
virtual property System::Collections::ICollection ^ Values { System::Collections::ICollection ^ get(); };public override System.Collections.ICollection Values { get; }member this.Values : System.Collections.ICollectionPublic Overrides ReadOnly Property Values As ICollection属性值
一个 ICollection，包含 SqlConnectionStringBuilder 中的值。
示例
以下示例首先新建一个 SqlConnectionStringBuilder，然后循环访问该对象内的所有值。
using System.Data.SqlClient;
class Program
{
static void Main()
{
SqlConnectionStringBuilder builder =
new SqlConnectionStringBuilder(GetConnectionString());
// Loop through each of the values, displaying the contents.
foreach (object value in builder.Values)
Console.WriteLine(value);
Console.WriteLine("Press any key to continue.");
Console.ReadLine();
}
private static string GetConnectionString()
{
// To avoid storing the connection string in your code,
// you can retrieve it from a configuration file.
return "Data Source=(local);Integrated Security=SSPI;" +
"Initial Catalog=AdventureWorks; Asynchronous Processing=true";
}
}
Imports System.Data.SqlClient
Module Module1
Sub Main()
Dim builder As _
New SqlConnectionStringBuilder(GetConnectionString())
' Loop through each of the values, displaying the contents.
For Each value As Object In builder.Values
Console.WriteLine(value)
Next
Console.WriteLine("Press any key to continue.")
Console.ReadLine()
End Sub
Private Function GetConnectionString() As String
' To avoid storing the connection string in your code,
' you can retrieve it from a configuration file.
Return "Data Source=(local);Integrated Security=SSPI;" & _
"Initial Catalog=AdventureWorks; Asynchronous Processing=True"
End Function
End Module
注解
ICollection 中的值的顺序未指定，但与 ICollection 属性返回的 Keys 中的关联键顺序相同。 因为每个 SqlConnectionStringBuilder 实例始终包含相同的固定键集合，所以 Values 属性始终返回与固定键集合相对应的值，顺序与键相同。
