Running dotnet ef database update on tfs build agent

entity-framework-core tfs

Question

I'm trying to make a CD setup which migrates my target database on release in TFS 2017 (update 3). My artifacts only contains my website assemblies, with DB context and controllers etc. If I update my database during build (and not during release) I can run

dotnet restore dotnet ef database update

and it works nicely, but this ofcourse does not work during release, as the source code is not available in the artifacts, and dotnet restore requires the .csproj file.

Anyone have suggestion of how to set up migrations during release? Do I need to include my source in the artifacts?

I'm using .net core 2.0 and ef core 2.0

1
0
9/20/2017 10:26:25 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

If you run dotnet ef database update with the --verbose option, you'll see a call to dotnet exec ef.dll. This is the command you can use directly on the binaries without needing the source code.

0
9/25/2017 4:34:07 PM

Related Questions

Can't update database using EF Migrations after updating to EF 6.0.0-alpha

After updating my Entity Framework to version 6.0.0-alpha1 I cant update database. This is the error I'm getting:...PM> update-database -verbose Using StartUp project 'DataCenter'. Using NuGet project 'DataCenter.Domain'. Specify the '-Verbose' flag to view the SQL statements being applied to the target database. Target database is: 'datacenter' (D...
code-first ef-migrations entity-framework entity-framework-6
asked by Mahmoodvcs

EF Database first how to update model for database changes?

In a class library ...Ado.net Entity Data Model... is has generated POCO classes. These were generated fine for the first time. But database changes are not being reflected. In ...edmx... diagram right clicking and choosing ...Update Model from Database... show newly created table but it do not add table even after selecting it to add....I tried ru...
.net c# entity-framework entity-framework-5 entity-framework-6
asked by user576510

dotnet ef migrations {name} dotnet ef database update

I am learning Entity Framework core and code first today, by following a video on pluralsite to create my own dbcontext. My project does create a database, but it is not doing it in SQL Server. When I create a context instance and look, it says database facade so I assume it is in memory. Where can I change a flag, or set a digit somewhere in the ...
c# entity-framework-core
asked by daniel Snyder

EntityFrameworkCore how to run "Update-Database" & "Add-Migration" from Visual Studio Code (VSCode)

I am trying EntityFrameworkCore in Visual Studio Code and I want to run "Update-Database" and "Add-Migration' commands, but there is no Package Manager Console in VSCode. what to do?
entity-framework-core visual-studio-code
asked by Mkhairy

Asp.net core on linux - dotnet ef database update fails with version error

Just followed the install instructions on ...https://www.microsoft.com/net/core#linuxubuntu... and ...https://docs.microsoft.com/en-us/aspnet/core/getting-started...Everything is fine so far, except when creating a new user under ...http://localhost:5000/Account/Register... it fails with ...SQLite Error 'no such table: AspNetUsers'...Tried with ....
asp.net asp.net-core entity-framework-core linux sqlite
asked by MarkusEgle

Running dotnet ef migrations for class library gives error MSB4006

I have an ASP.NET Core Web Application (.NET Framework) project targeting .NET Framework 4.6.2....I have introduced Entity Framework into the web project and have set up and run...dotnet ef migrations add Initial ...from the web project directory. The migration is created, all is good....I want to refactor the code so that my entities and db contex...
entity-framework-core
asked by fractor

Run different database types in different environments in dotnet core 2

I want to run a SQLite database in development and a SQLServer Express database in production....We are using code first with database migrations....How do I inject a different dbcontext in each environment?...How do I run migrations against a specific database. E.g. In development I'll want to run migrations against the SQLite database.
.net-core asp.net-core entity-framework entity-framework-6 sqlite
asked by Ryan Walls

Any way to run dotnet-ef from a published app

I'm constructing a docker container from a Dotnet Core 2.0 WebApp that was packaged with ...dotnet publish..., but publishing this way doesn't copy the extensions in ...Microsoft.EntityFrameworkCore.Tools.DotNet... that enable the ...dotnet-ef... command....Specifically, I want to run ...dotnet ef... commands in the container, but I get this error:...
.net-core c# docker entity-framework-core
asked by mikebridge

"dotnet ef database update" programatically with Entity Framework Core

I'd like to call these migrations from a script and while there's plenty of information on how to do that with Entity Framework standard there's very little with Entity Framework Core....I believe that this is the command that I need but I'm not sure on how to instantiate it properly or where the underlying classes are....https://github.com/aspnet/...
asp.net-core c# entity-framework entity-framework-core
asked by Richard Vanbergen

How to run "dotnet ef migrations script" from the last migration

In Azure DevOps I have a build task with the following command:...dotnet ef migrations script --output path/migrations-script.sql --idempotent ...In my release pipeline I run the generated script....The issue I've got is that the above command runs from the first migration. I know I can specify a ...from... argument for this command, but you have t...
azure-devops entity-framework-core
asked by aic

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