This topic has not yet been rated - Rate this topic

DbConnectionStringBuilder.Count Property

.NET Framework 4

Other Versions

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

Namespace: System.Data.Common
Assembly: System.Data (in System.Data.dll)

Syntax

C++

Copy

[BrowsableAttribute(false)]
public virtual int Count { get; }

Property Value

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

Implements

ICollection.Count

Examples

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

Copy


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

Version Information

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Platforms

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Reference

DbConnectionStringBuilder Class

System.Data.Common Namespace

Other Resources

Connection Strings (ADO.NET)

ADO.NET Managed Providers and DataSet Developer Center

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ