Work with one dbContext and multiple connection string in EntityFramework and .net core dependency injection

Question

I'm working in a project using EntityFramework Core and .net core 2.0, which I need to connect to multiple databases to get data to execute a cron, I injected DbContext.cs in startup.cs like above:

  services.AddDbContext<DbContext.cs>();

I use it in my UnitOfWork.cs like this:

public class UnitOfWork<Context> : IUnitOfWork where Context : DbContext
    {
        public DbContext _context { get; set; }

        public DbContext getContext()
        {
            return _context;
        }
        public UnitOfWork(DbContext context)
        {
            _context = context;
        }
}

which is also managed by dependency injection.

My question is, is it possible to work with a one injected instance of dbcontext, and change the connection at runtime in need? I really didn't find a clear solution for that. I tried to use a setter and to instantiate a new dbContext every time I need to connect to a new database, but it doesn't seem so beautiful:

public void SetContext(DbContext context)
        {
            _context = context;
        }
public DbContext _context { get; set; }

David Browne - Microsoft · Accepted Answer · 2018-06-12 13:39:07Z

1

is it possible to work with a one injected instance of dbcontext, and change the connection at runtime in need,

No. If your Unit Of Work needs to connect to multiple databases, you need multiple DbContext instances.

answered Jun 12, 2018 at 13:39

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

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

2 Comments

Boubakr Chieb Over a year ago

so there is no way to change connection string in runtime and connect to different databases using the same DbContext ?

David Browne - Microsoft Over a year ago

No. You must use a separate DbContext for each database.

Collectives™ on Stack Overflow

Work with one dbContext and multiple connection string in EntityFramework and .net core dependency injection

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related