Alessio Menichetti
Alessio Menichetti

Reputation: 89

How to change connection string on command line to update database on migration to a new database in Entity Framework Core

In ASP.NET Core and EF Core Code First, I have a multi-tenant webapp. When I create a new tenant, I want to change connection string, add migration on it and then update.

From command line, add migration can't get connection string dinamically on tenant and so i haven't a valid connection string for create a new database in the first time the app starts with a new tenant. Is there any solution for it? Thanks

Upvotes: 8

Views: 4470

Answers (2)

Georg Patscheider
Georg Patscheider

Reputation: 9463

Are you looking for this? Edit: this is for EF 6.1

Update-Database –ConnectionString "Data Source=YourDatabaseServer; Initial Catalog=YourDatabase; Integrated Security=True;"

Upvotes: 3

Alessio Menichetti
Alessio Menichetti

Reputation: 89

I solved by inserting inside the DbContext constructor:

Database.EnsureCreated();

Thanks for your reply.

Upvotes: -1

Related Questions