CODEWITHSUNDEEP
c#asp.netsqlado.net
Imran Rizvi
Imran Rizvi

Reputation: 7438

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?

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?)

Upvotes: 114

Views: 156300

Answers (8)

Joseph Wambura
Joseph Wambura

Reputation: 3396

If you are using .Net EF Core

using (var dbContext = new AppDbContext(serviceProvider.GetRequiredService<DbContextOptions<AppDbContext>>()))
{
  var dbConnection = dbContext.Database.GetDbConnection();

  //var serverName = dbConnection.DataSource;
  //var databaseName = dbConnection.Database;
}

Upvotes: 1

unarity
unarity

Reputation: 2445

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...

Upvotes: 55

Romil Kumar Jain
Romil Kumar Jain

Reputation: 20745

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;

Upvotes: 178

nawfal
nawfal

Reputation: 73173

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;

Upvotes: 42

pvaju896
pvaju896

Reputation: 1417

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.

Upvotes: 7

Kishore Kumar
Kishore Kumar

Reputation: 12874

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

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectString);

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

Upvotes: 13

Habib
Habib

Reputation: 223247

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

Upvotes: 5

Dennis
Dennis

Reputation: 37770

Database name is a value of SqlConnectionStringBuilder.InitialCatalog property.

Upvotes: 5

Related Questions