Managing EF migrations in Azure DevOps Pipeline
So our team has implemented a Windows self-hosted Azure DevOps testing pipeline. It was working well until we ran the backend tests for a branch that had a database migration. Although the tests passed as expect, this migration changed the agent's database. This resulted in every subsequent integration test run on the master branch to fail. Normally it would just 'down' the migration and it would be fine but here that migration doesn't exist since it was in a branch that hasn't been merged into master yet.
I've looked at a bunch of other posts about EF migrations and they all seem to talk about release pipelines and creating new migrations. All I want to do is have a step at the end of my pipeline that can update the database to whatever master's most recent migration is. However, I can't figure out how to do that since I don't have access to the NuGet Packet Manager Console. Does anyone know how I might go about updating the database to the appropriate migration? I am also pretty new to Azure DevOps pipelines so please let me know if this is misguided for whatever reason. Thank you for your help and please let me know if I can provide any more information.
If it is any help this is what we would use to update the database based on a given target migration in the NuGet Packet Manager Console:
Update-Database -projectName <projectName> -targetMigration <targetMigration> -configurationTypeName <configurationType> -connectionStringName <connectionString>
So I guess the big problem I was running into is that my project is using EF 6 but most of the solutions online want you to use dotnet commands. To my knowledge (please let me know if I am mistaken) EF 6 can't use dotnet commands.
To get around this I used ef6.exe which allows you to make migrations via the command line. In the pipeline I just move that ef6.exe to where my project assembly file is and execute the migration. This worked for me but for anyone using EF Core, PatrickLu-MSFT's solution should work and be more straight forward.
Even though it was changed in EF 6.3 from migrate.exe it doesn't look like Microsoft has updated the docs for ef6.exe. To get an idea of what it is you can look at the out of date migrate.exe documentation and then the conversion table that was posted as a github comment.
Conversion table from github comment linked above
- Run code after all EF Core migrations are applied
- Why can't I install Microsoft.EntityFrameworkCore.Sqlite?
- Paging Support - ADO.NET Entitry Framework and LINQ
- I have a SQL query and I want to convert it to linq
- Why I am getting Cascade delete cycle error when updating the database
- Entity framework Invalid Column name, EF adds number 1 to primary key
- How can I implement DbContext Connection String in .NET Core?
- Entity Framework | Sequence contains more than one matching element
- Entity Framework error: Cannot insert explicit value for identity column in table
- Does EntityFrameworkCore async method use different thread than the one which DbContext is created?
- I am try to Pagination using Skip Take in Code Frist Approach But given Error
- Entity Framework Core multiple connection strings on same DBContext?
- ASP.NET MVC. PagedList filtering by multiple params
- Why string property must be declared as nullable string in Entity Framework Core when corresponding database table column is nullable
- Is there is a C# function which is similar to .Map() in JavaScript?
- Unable to update database to match the current model because there are pending changes
- EF .NET 6 Data Annotations with database-first: cannot make annotations work
- How do I call SQLitePCL.Batteries.Init().?
- String or binary data would be truncated. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904)
- Is there a reason for using the Repository pattern with Entity Framework if I know I will only ever use EF?
- Invalid object name 'dbo.AspNetUsers' in Asp.NET MVC 5 Entity Framework
- EF6.5 SetExecutionStrategy vs SetTransactionHandler
- C# Entity Framework: Keyword not supported: 'port'
- Using Global Query Filters for all entities
- Test for schema changes in Entity Framework migration
- LINQ: Why does a union of a union throw error message "IQueryable<...> does not contain a definition for 'Union'"?
- Map Table Column to Enum and Lookup Table to Enum
- How to automatically call Entity Framework's update from database without Visual Studio
- Multiple Tables With Same Structure Entity Framework
- NpgsqlException while connecting to Postgres: ERROR: 3D000: odyssey: c16b9035a1f78: route for 'template1.xxx' is not found