How can I get the value from connection string?

Question

I have connection string:

<add name="fullDataBase"  
     connectionString="Data Source=.;Initial Catalog=Equipme;Integrated Security=True" 
     providerName="System.Data.SqlClient"/>

And then I can get name of catalog from it when I get this string using:

 string connectionString = ConfigurationManager.ConnectionStrings[_connectionString].ConnectionString;

In my case it should be Equipme

Answer 1

Use the SqlConnectionStringBuilder class:

string initialCatalog = new SqlConnectionStringBuilder(connectionString).InitialCatalog;

Answer 2

This is your solution

System.Data.SqlClient.SqlConnectionStringBuilder builder = New System.Data.SqlClient.SqlConnectionStringBuilder(System.Configuration.ConfigurationManager.ConnectionStrings("fullDataBase").ToString()))
string initialCatalog=builder.InitialCatalog()

The SqlConnectionStringBuilder will create a ConnectionString or it will break the connection string into individual parts line Database name etc..