CODEWITHSUNDEEP
asp.net-mvcentity-frameworkentity
K.Z
K.Z

Reputation: 5075

use multiple dbContext in one application

I am struggling with using multiple dbContext with an single web application in ASP.NET MVC 5. I am following code First existing database design approach.

i need guideline how to do that say in example if i am creating 5 models using ADO.NET, it will create 5 dbContext along with its model classes.

how it will change in web.config file?

Many Thanks

 public partial class DefaultContext : DbContext
{
    public DefaultContext()
        : base("name=DefaultContext")
    {
    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        throw new UnintentionalCodeFirstException();
    }

    public virtual DbSet<AspNetRole> AspNetRoles { get; set; }
    public virtual DbSet<sys_Actions> sys_Actions { get; set; }
    public virtual DbSet<sys_ActionsInRole> sys_ActionsInRole { get; set; }
    public virtual DbSet<sys_Controllers> sys_Controllers { get; set; }
    public virtual DbSet<sys_Functions> sys_Functions { get; set; }
    public virtual DbSet<sys_FunctionsHierarchy> sys_FunctionsHierarchy { get; set; }
}

Upvotes: 0

Views: 3783

Answers (1)

Mohammad Shahrouri
Mohammad Shahrouri

Reputation: 384

basically for each dbContext you need to add a new connection string with unique name in the connectionStrings section in your web.config file

here is an example:

<connectionStrings>
    <add name="dbContext1" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=dbServer;initial catalog=db1;integrated security = true;multipleactiveresultsets=True;application name=EntityFramework&quot;" providerName="System.Data.EntityClient" />
    <add name="dbContext2" connectionString="metadata=res://*/Model2.csdl|res://*/Model2.ssdl|res://*/Model2.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=dbServer;initial catalog=db1;integrated security = true;multipleactiveresultsets=True;application name=EntityFramework&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

Upvotes: 1

Related Questions