How to get Database Name from Connection String using SqlConnectionStringBuilder

Question

I never want to split connection string using string manipulation and get server database uid and password   I read the following link and read the accepted answer   I found that is the best way to get userid and password out from connection string  but what about Database Name    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

User · Answer

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;

User · Answer

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

User · Answer

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

User · Answer

this gives you the Xact   System Data SqlClient SqlConnectionStringBuilder connBuilder   new System Data SqlClient SqlConnectionStringBuilder     connBuilder ConnectionString   connectionString   string server   connBuilder DataSource              - gt  this gives you the Server name  string database   connBuilder InitialCatalog        - gt  this gives you the Db name

User · Answer

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

User · Answer

Database name is a value of SqlConnectionStringBuilder InitialCatalog property

User · Answer

string connectString    Data Source  local       Integrated Security true    SqlConnectionStringBuilder builder   new SqlConnectionStringBuilder connectString    Console WriteLine  builder InitialCatalog       builder InitialCatalog

[c#] How to get Database Name from Connection String using SqlConnectionStringBuilder

Examples related to c#

Examples related to asp.net

Examples related to sql

Examples related to ado.net