Home > DeveloperSection > Forums > How can I show the database name to my visitors in MVC4/Razor?
john rob

Total Post:108

Posted on    April-03-2013 2:28 AM


 1 Reply(s)
 1257  View(s)
Rate this:
Hi Everyone!

I would like to inform my visitors of which database they are currently interacting with. My application only has a single Entity Framework connection 

string in it's web.config. The database name (initial catalog) is part of my connection string stored in my web.config.

I can expose the ENTIRE connection string in the shared layout by including the following html.

You are connecting to <span class="databasename">@System.Configuration.ConfigurationManager.ConnectionStrings

But I don't need the entire connection string only the database name. Is there a way to do this without involving a controller or instantiating a new 

SqlConnection()? Any suggestions?
of this given set.

Is my database bad designed? What would be the best way to do this or how to make the SELECT query

Thanks in advance!


Total Post:604

Posted on    April-03-2013 8:19 AM

Hi John!

You can try this way

    var vDB = new System.Data.SqlClient.SqlConnectionStringBuilder(
    var vName = vDB.InitialCatalog;

bind into span <span class="databasename">@vName</span>!

Don't want to miss updates? Please click the below button!

Follow MindStick