Removed database out of connection string

Question

I was given a method to get our database connection string to Sql Server:

SqlConnection GetConnectionString()

I call that and get what the connection string should be. If the database does not exist, I need the connection string without the database name in it. If I try to use the connection string with the database name in it, I get an error that it cannot connect to the database, which is it since it does not exist.

I am calling like this:

using (var connection = new SqlConnection(GetConnectionString().ConnectionString))

Is there a way to recreate the connection string easily without the database name?

Answer 1

SqlConnectionStringBuilder aBuilder = 
   new SqlConnectionStringBuilder(yourConnectionStringWithDatabase);
aBuilder.InitialCatalog = "";

string yourConnectionStringWithoutDatabase = aBuilder.ConnectionString;