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

Question

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

Georg Patscheider · Accepted Answer · 2017-09-26 13:19:40Z

3

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

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

edited Sep 26, 2017 at 13:19

answered Aug 18, 2016 at 9:03

Georg Patscheider

9,4911 gold badge28 silver badges37 bronze badges

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

Comments

Alessio Menichetti · Accepted Answer · 2016-08-18 09:39:18Z

-1

I solved by inserting inside the DbContext constructor:

Database.EnsureCreated();

Thanks for your reply.

answered Aug 18, 2016 at 9:39

Alessio Menichetti

891 silver badge2 bronze badges

2 Comments

Brad Over a year ago

That's not a good solution. Every time an instance of your DbContext is created it will perform this check. You want to perform migrations once on startup. See my answer here stackoverflow.com/a/38283080/5782634

Alessio Menichetti Over a year ago

Thank you, your solution is better than mine. The important is to create at least one migration for each context.

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related