Getting initial catalog from the web.config file

find connection-string
Chris picture Chris · Feb 24, 2011 · Viewed 11.3k times · Source

I have a connection string in the web.config file. I have to get the database name from it. Let say my connection sting is 

<add name="LocalSqlServer" connectionString="Data Source=XYZ;Initial Catalog=MyDataBase;Integrated Security=true" providerName="System.Data.SqlClient"/>

I want to get the database name [i.e. Initial Catalog] from the connection string.

How can I get it?

Answer

marc_s picture marc_s · Feb 24, 2011

You can use the SqlConnectionStringBuilder for this purpose:

string connectionString = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);

string database = builder.InitialCatalog;

Related questions

How do I find all files containing specific text on Linux?

I'm trying to find a way to scan my entire Linux system for all files containing a specific string of text. Just to clarify, I'm looking for text within the file, not in the file name. When I was looking …

Read More
Python: Find in list

I have come across this: item = someSortOfSelection() if item in myList: doMySpecialFunction(item) but sometimes it does not work with all my items, as if they weren't recognized in the list (when it's a list of string). Is this the …

Read More
How to exclude a directory in find . command

I'm trying to run a find command for all JavaScript files, but how do I exclude a specific directory? Here is the find code we're using. for file in $(find . -name '*.js') do java -jar config/yuicompressor-2.4.2.jar --type …

Read More