got issue with using multiple dbContext in ASP.NET MVC 5

Question

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.

so i have created dashboardModel using ADO.NET Entity model, that comes with its own dbContext (DashboardContext) and then roleModel using again ADO.net Entity Model (dbContext = RoleContext).

I want to keep similar concern of model separtate and their individual DBContext.

On creating DashboardModel, code run without problem but when i have created RoleModel and run; it gives me error on Dashboard controller ==> MetadataException was unhandled by user code

public DashboardContext()
        : base("name=DashboardContext")
    {
    }

////

    public class DashboardController : Controller
{
    //
    // GET: /Dashboard/
    public ActionResult Home()
    {
        using (var db = new DashboardContext())
        {
            var query = from b in db.sys_Functions
                        orderby b.Function_ID
                        select b;

            foreach(var item in query)
            {
                var a1 = item.Title;
            }
        }

        return View();
    }
}

//

 public RoleContext()
        : base("name=RoleContext")
    {
    }

//

 public class TestController : Controller
{
    //
    // GET: /Test/
    public ActionResult Index()
    {
        using(var db = new RoleContext())
        {
            var query = from x in db.AspNetRoles
                        orderby x.Name
                        select x;

            foreach(var item in query)
            {
                var t = item.Name;
            }
        }

        return View();
    }
}

Many Thanks

Darin Dimitrov · Accepted Answer · 2013-12-10 15:25:05Z

2

I want to keep similar concern of model separtate and their individual DBContext.

DbContext is the abstraction for a database. So unless you are connecting your entities to different databases, there's no reason to use different Db contexts.

answered Dec 10, 2013 at 15:25

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

K.Z Over a year ago

my issue is i want to keep model separate based on business concern. When you use Design method to create ADO.NET Entity Model, it always create dbContext????

Corey Adler Over a year ago

I think @toxic is trying to do something like this: msdn.microsoft.com/en-us/magazine/jj883952.aspx

K.Z Over a year ago

i didn't know the concept title but yes this is what i am trying to achieve

Adel Mourad · Accepted Answer · 2021-03-04 06:49:04Z

Note: this may not be so related to the question

I wanted to make two ApplicationDbContext with two different connections in ASP.NET MVC 5 (not ASP.NET CORE)

This is what worked for me, first you will need to add a second / overloaded constructor to ApplicationDbContext

Then add another ApplicationDbContext class like "ReadOnly_1_Local_ApplicationDbContext" that inherits the orignial ApplicationDbContext not the "IdentityDbContext" and make its constructor calls the overloaded base constructor with your new connection

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public ApplicationDbContext() : base("<your connection>", throwIfV1Schema: false)
    {

    }

    public ApplicationDbContext(string nameOrConnectionString) : base(nameOrConnectionString, throwIfV1Schema: false)
    {

    }

    public static ApplicationDbContext Create()
    {
        return new ApplicationDbContext();
    }
}


public class ReadOnly_1_Local_ApplicationDbContext : ApplicationDbContext
{
    public ReadOnly_1_Local_ApplicationDbContext() : base("<your read only connection>")
    {

    }
}

Usage (I stopped sync from the first db to the read only one and changed the data in one of them to see it really connects to the other db)

public ActionResult TestMultiDbContext_1()
{
    var db_context = new ApplicationDbContext();
    return Content(db_context.Shipments.Find(123456).CustomerName); // name #1
}

public ActionResult TestMultiDbContext_2()
{
    var db_context = new ReadOnly_1_Local_ApplicationDbContext();

    return Content(db_context.Shipments.Find(123456).CustomerName); //name #2
}

That is tested with code first migrations and does not cause any issue and is not generating any extra migrations.

If you are adding another connection for entirely new db (not duplicated one), just make another class that inherits the IdentityDbContext normally

Thanks

Collectives™ on Stack Overflow

got issue with using multiple dbContext in ASP.NET MVC 5

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related