DbConnectionStringBuilder.Count Property

Reference

Definition

Namespace:: System.Data.Common

Assembly:: System.Data.Common.dll

Assemblies:: netstandard.dll, System.Data.Common.dll

Assembly:: System.Data.dll

Assembly:: netstandard.dll

Source:: DbConnectionStringBuilder.cs

Source:: DbConnectionStringBuilder.cs

Source:: DbConnectionStringBuilder.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets the current number of keys that are contained within the ConnectionString property.

public:
 virtual property int Count { int get(); };

public virtual int Count { get; }

[System.ComponentModel.Browsable(false)]
public virtual int Count { get; }

member this.Count : int

[<System.ComponentModel.Browsable(false)>]
member this.Count : int

Public Overridable ReadOnly Property Count As Integer

Property Value

Int32

The number of keys that are contained within the connection string maintained by the DbConnectionStringBuilder instance.

Implements

Count

Attributes: BrowsableAttribute

Examples

The following example demonstrates the Count property both before and after you modify the contents of the ConnectionString property.

static void Main()
{
    DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
    builder.ConnectionString =
        "Data Source=(local);Initial Catalog=AdventureWorks;" +
        "Integrated Security=SSPI";

    // This should display "3" in the console window.
    Console.WriteLine("Original count: " + builder.Count);

    builder.Add("Connection Timeout", 25);

    // This should display the new connection string and
    // the number of items (4) in the console window.
    Console.WriteLine(builder.ConnectionString);
    Console.WriteLine("New count: " + builder.Count);

    Console.WriteLine();
    Console.WriteLine("Press Enter to finish.");
    Console.ReadLine();
}

Sub Main()
    Dim builder As New DbConnectionStringBuilder
    builder.ConnectionString = _
        "Data Source=(local);Initial Catalog=AdventureWorks;" & _
        "Integrated Security=SSPI"

    ' This should display "3" in the console window.
    Console.WriteLine(builder.Count)

    builder.Add("Connection Timeout", 25)

    ' This should display the new connection string and
    ' the number of items (4) in the console window.
    Console.WriteLine(builder.ConnectionString)
    Console.WriteLine(builder.Count)

    Console.WriteLine()
    Console.WriteLine("Press Enter to finish.")
    Console.ReadLine()
End Sub

Applies to

Product	Versions
.NET	Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1
UWP	10.0

Share via