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

Total Post:108

Points:756
Posted on    April-03-2013 2:28 AM

 ASP.NET MVC ASP.NET MVC 
Ratings:


 1 Reply(s)
 1043  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

["MyConnectionStringName"].ConnectionString)</span>!
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!


AVADHESH PATEL

Total Post:604

Points:4228
Posted on    April-03-2013 8:19 AM

Hi John!

You can try this way

@{
    var vDB = new System.Data.SqlClient.SqlConnectionStringBuilder(
        System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString)
    );
    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