How to run EF Core migrations on SQL Server database using Docker?

Question

On a Mac I have a Net Core 2.1 Class Library with a few Entity Framework migrations.

I need to use Docker to run SQL Server and update the database with the previews migrations.

I added a docker-compose.yml file to my project:

docker-compose.yml
src
  data
    project.data.csproj

The docker-compose.yml file is the following:

services:
  data:
    build: .
    depends_on:
      - database
  database:
  image: "microsoft/mssql-server-linux"
  environment:
    SA_PASSWORD: "Pass.word123"
    ACCEPT_EULA: "Y"

At the moment this is not working.

How can I run EF Core migrations on SQL Server using docker in a Mac?

Off the top of my head there's two ways, have Docker execute dotnet ef database update during the container build or at run time you can use Database.Migrate(), which would suit your case? — Adam Vincent
– Adam Vincent, Commented Nov 8, 2018 at 1:35
What you're asking for is in discussion in this issue on GitHub — Adam Vincent
– Adam Vincent, Commented Nov 8, 2018 at 13:05
It's a good question, but I don't think there's a solid solution at this time. — Adam Vincent
– Adam Vincent, Commented Nov 8, 2018 at 13:06
As @AdamVincent suggested, runtime migration looks like natural solution to me. If you for some reason want to run migration by hand, add some parameter to program/appsettings to control the behaviour — Karel Křesťan
– Karel Křesťan, Commented Oct 25, 2020 at 18:04

Adrian Mole · Accepted Answer · 2021-06-13 22:09:50Z

3

You need to add below lines in Confiure of startup file. It will executed when the application is started. It will update all the migration files to database.

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

This worked for me.

edited Jun 13, 2021 at 22:09

Adrian Mole

52.2k193 gold badges61 silver badges101 bronze badges

answered Jun 13, 2021 at 8:01

Gopi

1021 silver badge13 bronze badges

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

Collectives™ on Stack Overflow

How to run EF Core migrations on SQL Server database using Docker?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related