//public MiddleOfficeEntities(string connStringName)

        //  : base(connStringName)

        //{

        //  this.Database.Connection.ConnectionString = connStringName;

        //}

    <DropCopyDataBase>

        <DataBases>

            <add name="Middle_001" broker="002" server="STAW-001" database="MiddleOffice_001" user="blk" password="blk123" />

            <add name="Middle_002" broker="001" server="STAW-001" database="MiddleOffice_002" user="blk" password="blk123" />

            <add name="Middle_003" broker="003" server="STAW-001" database="MiddleOffice_003" user="blk" password="blk123" />

        </DataBases>

    </DropCopyDataBase>

​

    <connectionStrings>

        <!--<add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-MiddleOffice.DropCopy.WebService-20141018221315;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MiddleOffice.DropCopy.WebService-20141018221315.mdf" />-->

        <add name="MiddleOfficeEntities_001" connectionString="metadata=res://*/MiddleOffice.csdl|res://*/MiddleOffice.ssdl|res://*/MiddleOffice.msl;provider=System.Data.SqlClient;provider connection string="data source=STAW-001;initial catalog=MiddleOffice_001;user id=blk;password=blk123;encrypt=True;trustservercertificate=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />

        <add name="MiddleOfficeEntities_002" connectionString="metadata=res://*/MiddleOffice.csdl|res://*/MiddleOffice.ssdl|res://*/MiddleOffice.msl;provider=System.Data.SqlClient;provider connection string="data source=STAW-001;initial catalog=MiddleOffice_002;user id=blk;password=blk123;encrypt=True;trustservercertificate=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />

        <add name="MiddleOfficeEntities_003" connectionString="metadata=res://*/MiddleOffice.csdl|res://*/MiddleOffice.ssdl|res://*/MiddleOffice.msl;provider=System.Data.SqlClient;provider connection string="data source=STAW-001;initial catalog=MiddleOffice_003;user id=blk;password=blk123;encrypt=True;trustservercertificate=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />

    </connectionStrings>

    ====================================================================================================================================

    using (var context = new MiddleOfficeEntities())

    {

        Trace.WriteLine("DB: " + context.Database.Connection.Database + 

            " - " + context.Database.Connection.ConnectionString + 

            " - " + context.Database.Connection.State);

        context.Database.Connection.ConnectionString = entityConnectionStringBuilder.ProviderConnectionString;

​

        Trace.WriteLine("DB: " + context.Database.Connection.Database +

            " - " + context.Database.Connection.ConnectionString +

            " - " + context.Database.Connection.State);

​

​

        list = context.TbLogError.ToList();

        list.ForEach(item => Trace.WriteLine(item.ToString()));

    }

    ====================================================================================================================================

using System.Collections.Generic;

using System.Configuration;

using System.Linq;

​

namespace MiddleOffice.DropCopy.Data

{

    /*

     Custom Config

     * 

    <configSections>

        <section name="DropCopyDataBase" type="MiddleOffice.DropCopy.Business.DropCopyDataBaseSection"/>

    </configSections>

​

    <DropCopyDataBase>

        <DataBases>

            <add name="Middle_001" server="STAW-001" database="MiddleOffice_001" user="blk" password="blk123" />

            <add name="Middle_002" server="STAW-001" database="MiddleOffice_002" user="blk" password="blk123" />

            <add name="Middle_003" server="STAW-001" database="MiddleOffice_003" user="blk" password="blk123" />

        </DataBases>

    </DropCopyDataBase>

     */

​

​

    /// <summary>

    /// Declaração do Objeto que instanciará os valores unitários do Web.Config

    /// </summary>

    /// <example></example>

    public class MultiDataBase

    {

        public static DropCopyDataBaseSection Config = ConfigurationManager.GetSection("DropCopyDataBase") as DropCopyDataBaseSection;

        public static DbElementCollection GetDataBases()

        {

            return Config.DataBases;

        }

​

        public static Dictionary<int, DbElement> GetDictionary()

        {

            return Config.DataBases.Cast<object>().ToDictionary<object, int, DbElement>(item => ((DbElement)item).Broker, item => (DbElement)item);

        }

​

​

        public static DbElementCollection GetDataBaseByBroker(int broker = 0)

        {

            if (broker == 0)

                return null;

            else

                return Config.DataBases;

        }

    }

​

    /// <summary>

    /// Declaração da Section que contém os elementos unitários

    /// </summary>

    public class DropCopyDataBaseSection : ConfigurationSection

    {

        [ConfigurationProperty("DataBases")]

        public DbElementCollection DataBases

        {

            get { return (DbElementCollection)this["DataBases"]; }

        }

    }

​

    /// <summary>

    /// Declaração da collection de todos os elementos unitários

    /// </summary>

    [ConfigurationCollection(typeof(DbElement))]

    public class DbElementCollection : ConfigurationElementCollection

    {

        public DbElement this[int index]

        {

            get { return (DbElement)BaseGet(index); }

            set

            {

                if (BaseGet(index) != null)

                    BaseRemoveAt(index);

​

                BaseAdd(index, value);

            }

        }

        protected override ConfigurationElement CreateNewElement()

        {

            return new DbElement();

        }

​

        protected override object GetElementKey(ConfigurationElement element)

        {

            return ((DbElement)element).Name;

        }

    }

​

​

    /// <summary>

    /// Declaração do elemento unitário

    /// </summary>

    public class DbElement : ConfigurationElement

    {

        [ConfigurationProperty("name", DefaultValue = "", IsKey = true, IsRequired = true)]

        public string Name

        {

            get { return (string)this["name"]; }

            set { this["name"] = value; }

        }

​

        [ConfigurationProperty("broker", DefaultValue = 0, IsKey = true, IsRequired = true)]

        public int Broker

        {

            get { return (int)this["broker"]; }

            set { this["broker"] = value; }

        }

​

        [ConfigurationProperty("server", DefaultValue = "", IsRequired = true)]

        public string Server

        {

            get { return (string)this["server"]; }

            set { this["server"] = value; }

        }

​

        [ConfigurationProperty("database", DefaultValue = "", IsRequired = true)]

        public string DataBase

        {

            get { return (string)this["database"]; }

            set { this["database"] = value; }

        }

​

        [ConfigurationProperty("user", DefaultValue = "", IsRequired = true)]

        public string User

        {

            get { return (string)this["user"]; }

            set { this["user"] = value; }

        }

​

        [ConfigurationProperty("password", DefaultValue = "", IsRequired = true)]

        public string Password

        {

            get { return (string)this["password"]; }

            set { this["password"] = value; }

        }

​

        public override string ToString()

        {

            return "Name: " + Name + " - Server: " + Server + " - DataBase: " + DataBase + " - User: " + User + " - Psw: " + Password;

        }

    }

​

}