Entity Framework Core on Azure: Update-Database parameter –ConnectionString does not work

Question

I want to update database on Azure SQL to fit .Net Core application using Entity Framework Core migrations. The following command is advised online:

Update-Database -ConnectionString $ConnectionString -ConnectionProviderName "System.Data.SqlClient"

However, it does not work since Update-Database cmdlet does not recognize parameter –ConnectionString. How can automate database migrations?

I think parameter should by `-Connection` not `-ConnectionString` — Vivek Nuna, Jun 19 '18 at 06:57
Supported parameters: `Update-Database [[-Migration] ] [-Context ] [-Project ] [-StartupProject ] []` — user2341923, Jun 19 '18 at 07:23
didn't get you. You need to use `Update-Database -Connection` — Vivek Nuna, Jun 19 '18 at 07:26
`Update-Database : A parameter cannot be found that matches parameter name 'Connection'.` — user2341923, Jun 19 '18 at 07:30
The question is: how can I tell to `Update-Database` which of the remote databases on Azure SQL is needed to be updated? — user2341923, Jun 19 '18 at 08:02

score 1 · Accepted Answer · answered Jun 19 '18 at 09:50

How can automate database migrations?

EF does not support Automatic migrations, you may need to manually execute Add-Migration or dotnet ef migrations add for adding migration files. You could explicitly execute the command to apply the migrations, also you could apply migrations in your code.

If you want to apply migration at runtime, you could add the following code int the Configure method of Startup.cs

using (var scope = app.ApplicationServices.GetService<IServiceScopeFactory>().CreateScope())
    {
        scope.ServiceProvider.GetRequiredService<ApplicationDbContext>().Database.Migrate();
    }

For more details, you could refer to this thread.

Entity Framework Core on Azure: Update-Database parameter –ConnectionString does not work

1 Answers1