EF Core migrations in Docker container

asp.net-core-2.0 docker entity-framework-core entity-framework-core-migrations

Question

I am setting up a WebApi in .NET Core 2.0. I will be using Entity Framework Core as ORM. Whole app will be deployed as Docker Container. The thing that disturbs me a bit is the way of handling DB migrations in this case. I mean PRODUCTION environment. Here is what I managed to research:

  • We just fire Database.Migrate() in the app start forgetting the whole world- hmm somehow I don't like it ;-)
  • Database.Migrate() driven by command-line param (run docker container once with a specified param to migrate DB)
  • Log into application container and execute dotnet ef database update
  • Generate plain old SQL based on migrations and execute it from DB management tool. Seems oldschool but valid. The thing I hate is to mess with executing scripts on my own.
  • Prepare a Database container that would already have scripts generated from code above, and that would automatically execute them.

Any other suggestions ? Or what is the best, most proper solution ?

Regards

1
38
5/16/2019 11:52:37 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

in my opinion it is your first point (Database.Migrate() due startup) which meets mostly our use case. So for me it`s currently the preferred way to do that.

We have some additional constellations in the starting up process:

  • Docker container locally only (for dev environment and testing for sure)
  • Own startup project which executes the Database.Migrate() part (cause we have more than one project with its own database)
  • Additional project with the actually API website :)

  • Production environment with Azure SQL server (Published and deployed through Azure DevOps pipeline

  • Migrations are created in its own project via dotnet ef ...

    dotnet ef migrations add "your migration name" --startup-project "path to your actually API" --context "database context name"

Important: you have to change the working directory to the migration project first in order to use another startup project but generate the migration files in the "migration project"

In our case it works fine with different APIs with their own databases behind the szene.

Regards

1
5/14/2019 7:54:52 AM

Related Questions

Cannot connect to SQL Server from a Docker container

We have created ASP NET Core App with existing sql server....const string connectionString = @"Server=hostname\sqlexpress;Database=DEVDB;User Id=sa;Password=password;"; services.AddDbContext<RecruitmentToolsDatabaseContext>(options => options.UseSqlServer(connectionString)); ...It works on windows. After creating docker image with same settings we ...
asp.net-core docker entity-framework-core linux sql-server
asked by bizon

EF Core migrations using asp.net core, SQL Server and Docker yields dotnet SDK error

I'm using Docker for Windows Version 1.13.0-rc5-beta35 (9606)...Windows 10 Pro...Visual Studio Code...I've created an ASP.NET Core project with Docker using the yeoman generator:...yo aspnet yo docker ...I ran into issues when I was trying to get the API to connect from a Docker container to a SQL Server instance I had running locally....To solve t...
asp.net-core docker entity-framework-core sql-server
asked by GreenyMcDuff

EF Core Migration Error "Could not drop constraint" which was removed in previous migration

Using Entity Framework Core Code-First development:...In the last migration I ran, I switched a relationship from (simplified)...public class SiteUser { public int Id {get; set;} public int EmployeeId { get; set; } [InverseProperty("SiteUser")] public virtual Employee Employee { get; set; } } public class Employee { public in...
c# entity-framework-core
asked by Kristen Hammack

Database migration with two context in Asp.Net Core (SQL Server on Docker)

I have two Context in my Application. One in ...WebApi Project -> ApiContext (inherited from IdentityDbContext)... and another one in ...Infrastructure -> Context.......I use Official images for Microsoft SQL Server on Linux for Docker Engine (...microsoft/mssql-server-linux...)....I wrote a ...DbFactory.... Below you can find my codes....ApiContex...
asp.net-core database-migration docker entity-framework entity-framework-core
asked by Cieja

Including Entity Framework tooling in docker container

I am using the ...aspnetcore... docker image to run an ASP.NET Core application using EF Core. Running the application works, but I am unable to use any tooling. ...Commands like ...dotnet ef database update... fail....Is it possible to run any ...DotNetCliToolReference... tooling without the full SDK?
.net-core asp.net-core c# entity-framework entity-framework-core
asked by Giffesnaffen

How to connect to SQL Sever docker container from another container?

I have pulled and run SQL Server 2017 container image using the following command:...docker pull microsoft/mssql-server-linux docker run --name mssql -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=!Abcd123' -p 1433:1433 -d microsoft/mssql-server-linux ...And I also deployed an ASP.NET Core Web API application to a Docker container, using the following commands...
asp.net-core asp.net-core-2.0 docker entity-framework-core sql-server
asked by WPInfo

How to connect to the database from host - sql server in container running under docker compose

I am running Sql Server on a container. I have set up the docker-compose and all services are able to connect to the database in order to perform design time entity framework core migrations. ...I would like to connect to the database from the host machine. This does not appear to work with the following code (using "port"). I get ..." A networ...
containers docker-compose entity-framework-core migration port
asked by Banoona

Apply Entity Framework migrations when using ASP.Net Core in a Docker image

I have an ASP.Net Core application which uses Entity Framework with Sqlite. I am building a Docker image to deploy this....The ASP.Net Core application runs fine when debugging with VS Code, but when running in a Docker container I receive an error:...SqliteException: SQLite Error 1: 'no such table: MyTable'....I figured this is because I need to r...
asp.net-core c# docker entity-framework-core
asked by Owen Pauling

Add-Migration while using database in separate Docker container throws an error

I've created dockerized ASP.net Core app with auto-generated identity setup (so I've already had by default entity framework configuration). I've created SQL Server as separate container, here is my ...docker-compose.yml...:...version: '3.4' services: blazorapp1: image: blazorapp1 build: context: . docke...
.net-core asp.net asp.net-core entity-framework entity-framework-core
asked by Piotrek

EF Core "no migrations found" despite Migrations folder containing migration files

We have a .NET Core project set up with a Migrations folder containing several migrations that we were able to successfully run in our Development database in the past by executing ...dotnet ef database update.... However, we are now trying to apply those changes to our Staging database and it isn't working. We've set our ...ASPNETCORE_ENVIRONMENT....
.net c# entity-framework-core
asked by emilyw26

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow