SqlConnectionStringBuilder.Values Property

Definition

获取一个包含 ICollection 中的值的 SqlConnectionStringBuilderGets an ICollection that contains the values in the SqlConnectionStringBuilder.

public:
 virtual property System::Collections::ICollection ^ Values { System::Collections::ICollection ^ get(); };
public override System.Collections.ICollection Values { get; }
member this.Values : System.Collections.ICollection
Public Overrides ReadOnly Property Values As ICollection

Property Value

ICollection

一个 ICollection,包含 SqlConnectionStringBuilder 中的值。An ICollection that contains the values in the SqlConnectionStringBuilder.

Examples

以下示例首先新建一个 SqlConnectionStringBuilder,然后循环访问该对象内的所有值。The following example first creates a new SqlConnectionStringBuilder, and then iterates through all the values within the object.

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

Remarks

ICollection 中的值的顺序未指定,但与 ICollection 属性返回的 Keys 中的关联键顺序相同。The order of the values in the ICollection is unspecified, but it is the same order as the associated keys in the ICollection returned by the Keys property. 因为每个 SqlConnectionStringBuilder 实例始终包含相同的固定键集合,所以 Values 属性始终返回与固定键集合相对应的值,顺序与键相同。Because each instance of the SqlConnectionStringBuilder always contains the same fixed set of keys, the Values property always returns the values corresponding to the fixed set of keys, in the same order as the keys.

Applies to

See also