Update database from models using entity framework in multi tenant .net core

Question

I am using .net core entity framework.

I have multi tenant dbs. so I have kept one root tenant db as base. and I want to replicate those schema changes to all other dbs using entity framework. I am generating my models using following command.

Scaffold-DbContext "Data Source=(local);Initial Catalog=sampleTenantDb;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Tenants -Force

So when creating new tenant, I simply use

context.Database.EnsureCreated();

But when I add new table in code, I want to apply it to all tenants. So how do I do it?

I tried following but, it doesn't work (not adding remanining tables)

myDbContext.Database.Migrate();

David Browne - Microsoft · Accepted Answer · 2020-02-29 18:33:16Z

1

If your DbContext is created with Scaffold-DbContext, it won't have any Migrations. That's for a database-first workflow, in which you would apply the DDL changes to the tenant databases with a script, perhaps created with SQL Server Data Tools.

answered Feb 29, 2020 at 18:33

David Browne - Microsoft

90.8k7 gold badges53 silver badges87 bronze badges

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

Comments

balvinder singh · Accepted Answer · 2020-02-29 17:56:20Z

1

You have need to create multiple dbcontext object and and pass connection string in that way you can update multiple db

answered Feb 29, 2020 at 17:56

balvinder singh

111 silver badge4 bronze badges

Collectives™ on Stack Overflow

Update database from models using entity framework in multi tenant .net core

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related