How to get Database Name from Connection String using SqlConnectionStringBuilder

I do not want to split connection strings using string manipulation functions to get Server, Database, Username, and Password.

I read the following link and read the accepted answer, I found that is the best way to get username and password out from connection string, but what about Database Name?

https://stackoverflow.com/questions/9975122/right-way-to-get-username-and-password-from-connection-string

How to get Database Name from Connection String using SqlConnectionStringBuilder. (does the DataSource is the Server name?)

You can use the provider-specific ConnectionStringBuilder class (within the appropriate namespace), or System.Data.Common.DbConnectionStringBuilder to abstract the connection string object if you need to. You'd need to know the provider-specific keywords used to designate the information you're looking for, but for a SQL Server example you could do either of these two things:

System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder(connectionString);

string server = builder.DataSource;
string database = builder.InitialCatalog;

or

System.Data.Common.DbConnectionStringBuilder builder = new System.Data.Common.DbConnectionStringBuilder();

builder.ConnectionString = connectionString;

string server = builder["Data Source"] as string;
string database = builder["Initial Catalog"] as string;

See MSDN documentation for InitialCatalog Property: > Gets or sets the name of the database associated with the connection... > This property corresponds to the "Initial Catalog" and "database" keys within the connection string...

A much simpler alternative is to get the information from the connection object itself. For example:

IDbConnection connection = new SqlConnection(connectionString);
var dbName = connection.Database;

Similarly you can get the server name as well from the connection object.

DbConnection connection = new SqlConnection(connectionString);
var server = connection.DataSource;

string connectString = "Data Source=(local);" + "Integrated Security=true";

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectString);

Console.WriteLine("builder.InitialCatalog = " + builder.InitialCatalog);

this gives you the Xact;

System.Data.SqlClient.SqlConnectionStringBuilder connBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();

connBuilder.ConnectionString = connectionString;

string server = connBuilder.DataSource;           //-> this gives you the Server name.
string database = connBuilder.InitialCatalog;     //-> this gives you the Db name.

Database name is a value of SqlConnectionStringBuilder.InitialCatalog property.

You can use InitialCatalog Property or builder["Database"] works as well. I tested it with different case and it still works.