/// <summary>
/// Gets all the values stored in the connectionStrings.
/// This will provide a single collection containing the defaults or
/// overrides as appropriate.
/// </summary>
/// <returns>The collection of all connection strings.</returns>
public ConnectionStringSettingsCollection GetConnectionStrings()
{
ConnectionStringSettingsCollection allConnections =
new ConnectionStringSettingsCollection();
// Put in all the default values
foreach (ConnectionStringSettings connSetting in
ConfigurationManager.ConnectionStrings)
{
allConnections.Add(connSetting);
}
if (m_overridenConfig.HasFile)
{
foreach (ConnectionStringSettings connSetting in
m_overridenConfig.ConnectionStrings.ConnectionStrings)
{
// Remove the default if already present
if (allConnections[connSetting.Name] != null)
{
allConnections.Remove(connSetting.Name);
}
allConnections.Add(connSetting);
}
}
return allConnections;
}