Break apart the connection string

It is sometimes useful to know which database you are connected to, here is a simple method that pulls apart the connection string and provides you with the section you request.

private static string GetSection(string section)
{
var connectionString = string.Empty;

Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot");
ConnectionStringSettings connString;

if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
connString = rootWebConfig.ConnectionStrings.ConnectionStrings["Entities"];
if (connString != null)
connectionString = connString.ConnectionString;
}

string[] parts = connectionString.Split(';');

for (int i = 0; i < parts.Length; i++)
{
string part = parts[i].Trim().ToLowerInvariant();
if (part.StartsWith($"{section}="))
{
return part.Replace($"{section}=", "");
}
}

return "Unknown";
}