Dbcontext: use other connection strings - Entityframework

Question

I have a file web.config with 4 connection strings. How can I put these connection strings in the class DbContext?

public DataContext():base("ConnectionString") // Essa é minha conexão padrão
{

}

How can I do the same using another connection?

Answer 1

When you create connection strings on the web.config you pass names to them in the name property. To choose one in your implementation DbContext Simply pass the base class constructor the connection name as it is in the name property on web.config. It’s like you did, but with the name of the other connections.

EDIT: An example would be the following, you add on web.config the following connection string

<connectionStrings>
    <add name="Exemplo" connectionString="ConnectionString" providerName="Provider" />
</connectionStrings>

Whereas ConnectionString is your connection string and Provider your predecessor, which in case and SQL Server is System.Data.SqlClient. So in your context, you would do the following

public class ContextoExemplo : DbContext
{
    public ContextoExemplo() : base("Exemplo") {}
}

Hence this context will sweat the connection string with name Example you added. Each context would simply have to put what goes in the name property there and EF knows what to use that connection string.